Re: Avoiding empty queries in tsearch

Поиск
Список
Период
Сортировка
От Doug Cole
Тема Re: Avoiding empty queries in tsearch
Дата
Msg-id 7b8d80330701151103g58a58083u7f3d37a934964c9d@mail.gmail.com
обсуждение исходный текст
Ответ на Avoiding empty queries in tsearch  ("Doug Cole" <doug@shackprices.com>)
Ответы Re: Avoiding empty queries in tsearch  (Oleg Bartunov <oleg@sai.msu.su>)
Список 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 по дате отправления:

Предыдущее
От: "Albert"
Дата:
Сообщение: Reserve a value in a serial type field
Следующее
От: Teodor Sigaev
Дата:
Сообщение: Re: Avoiding empty queries in tsearch