Re: Safe usage of tsearch2: to_tsquery('')

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Safe usage of tsearch2: to_tsquery('')
Дата
Msg-id 16851.1186241470@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Safe usage of tsearch2: to_tsquery('')  (cluster <skrald@amossen.dk>)
Ответы Re: Safe usage of tsearch2: to_tsquery('')
Список pgsql-general
Дерево обсуждения 
cluster <skrald@amossen.dk> writes:
> In a web application I would like to use tsearch2 to search for by-user
> entered key words. That is, the user provides the keywords in a space
> separated list in some input text field. For that I use
> to_tsquery('<user keywords>') but I would like to do this in a safe way
> so that the user cannot misuse to_tsquery() by entering some harmful string.

Isn't plainto_tsquery() what you're looking for?

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: pg_restore UTF8 problem
Следующее
От: Tom Lane
Дата:
Сообщение: Re: could not [extend relation|write block N of temporary file|write to hash-join temporary file]