tsearch2 problems in postgres? - Mailing list pgsql-general

From JohnSense
Subject tsearch2 problems in postgres?
Date
Msg-id 1185490290.742872.99420@57g2000hsv.googlegroups.com
Whole thread Raw
Responses Re: tsearch2 problems in postgres?  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-general
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


pgsql-general by date:

Previous
From: NetComrade
Date:
Subject: Question about Postgres
Next
From: Tony Crisera
Date:
Subject: create function error