Bind variables and progressive relaxation
352161Aug 20 2007 — edited Aug 21 2007Is is possible to use bind variables in a progressive relexation using the rewrite template as shown on http://www.oracle.com/technology/products/text/htdocs/prog_relax.html
I want to do something like
select score(1) scr, title, author from mybooks where contains (author, '
<query>
<textquery>:SOMEVAR
<progression>
<seq><rewrite>transform((TOKENS, "{", "}", " "))</rewrite></seq>
<seq><rewrite>transform((TOKENS, "?{", "}", " "))</rewrite>/seq>
<seq><rewrite>transform((TOKENS, "{", "}", "OR"))</rewrite></seq>
<seq><rewrite>transform((TOKENS, "?{", "}", "OR"))</rewrite></seq>
</progression>
</textquery>
</query>', 1) > 0)
but can't seem to get it working (it seems to just be matching on the string "SOMEVAR".