Re: Avoiding empty queries in tsearch

Поиск
Список
Период
Сортировка
От Doug Cole
Тема Re: Avoiding empty queries in tsearch
Дата
Msg-id 7b8d80330701151036y6319cea7o84bfa7cc7c07d4f7@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Avoiding empty queries in tsearch  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-general
That sounds perfect, but it doesn't seem to exist on either of the postgresql installations I have access to (8.1 on ubuntu and fedora core).  Is it new to 8.2?  Is there a similar function under 8.1, or at least a decent work-around?  Thanks for the help,
Doug

On 1/15/07, Teodor Sigaev <teodor@sigaev.ru> wrote:
contrib_regression=# select numnode( plainto_tsquery('the any') );
NOTICE:  query contains only stopword(s) or doesn't contain lexeme(s), ignored
  numnode
---------
        0
(1 row)

contrib_regression=# select numnode( plainto_tsquery('the table') );
  numnode
---------
        1
(1 row)

contrib_regression=# select numnode( plainto_tsquery('long table') );
  numnode
---------
        3
(1 row)


--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: [HACKERS] Checkpoint request failed on version 8.2.1.
Следующее
От: "richard lavoie"
Дата:
Сообщение: Elegant copy of a row using PL