tsearch2 problems in postgres?

From: JohnSense <sanmateoquest(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: tsearch2 problems in postgres?
Date: 2007-07-26 22:51:30
Message-ID: 1185490290.742872.99420@57g2000hsv.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stuart 2007-07-27 00:57:27 generating part of composite key
Previous Message Damian C 2007-07-26 20:36:09 Re: The database slows down after a few weeks