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
