Re: Adding an alternate syntax for Phrase Search

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Adding an alternate syntax for Phrase Search
Дата
Msg-id CAKFQuwYhxhJ1vSX1sJJcUR=bRpL6M5ow__+BAbHY2o8872NUZA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Adding an alternate syntax for Phrase Search  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-hackers
On Sun, May 22, 2016 at 6:53 PM, Teodor Sigaev <teodor@sigaev.ru> wrote:

to_tsquery(' Berkus & "PostgreSQL Version 10.0" ')

... would be equivalent to:

to_tsquery(' Berkus & ( PostgreSQL <-> version <-> 10.0 )')

select to_tsquery('Berkus') && phraseto_tsquery('PostgreSQL Version 10.0');
does it as you wish

​Sure, but I imagine (not having used it myself), that in cases involving user input said text treated somewhat holistically and it wouldn't be all that easy, or desirable, to choose between the two forms at runtime.

David J.​
 

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