Safe usage of tsearch2: to_tsquery('')

Поиск
Список
Период
Сортировка
От cluster
Тема Safe usage of tsearch2: to_tsquery('')
Дата
Msg-id f91mmo$1nfe$1@news.hub.org
обсуждение исходный текст
Ответы Re: Safe usage of tsearch2: to_tsquery('')
Список pgsql-general
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.
That is, a user input like
    "cars ford fast"
should be translated to
    "to_tsquery('cars|ford|fast')"
in a safe way.

How can I do that?

(I use postgresql from PHP)

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

Предыдущее
От: Rodrigo De León
Дата:
Сообщение: Re: Select question..... is there a way to do this?
Следующее
От: mwsenecal@yahoo.com
Дата:
Сообщение: Re: Require entry of MD5 hash instead of plaintext password?