Re: tsearch2 problems in postgres?

somewhere you need to use to_tsvector instead of to_tsquery.

Oleg
On Thu, 26 Jul 2007, JohnSense wrote:

> SELECT *, rank(ts_vec, to_tsquery('default', 'lc & 11(')) FROM us
> WHERE ts_vec @@ to_tsquery('default', 'lc & 11(') LIMIT 9 OFFSET 0
> this query gives an error
> in tsearch2
> saying syntax error
> any idea on how 2 strip the non safe tsearch stuff
> before feeding it to sql
> this is from a web search interface?
> psycopg2.ProgrammingError at /search ->
> if i give inpu as lc !! (
> is there a list of characters that need to stripped out before doing
> @@ in tsearch2
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

     Regards,
         Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83