tsearch2 problems in postgres?

Поиск
Список
Период
Сортировка
От JohnSense
Тема tsearch2 problems in postgres?
Дата
Msg-id 1185490290.742872.99420@57g2000hsv.googlegroups.com
обсуждение исходный текст
Ответы Re: tsearch2 problems in postgres?
Список 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 по дате отправления: