Re: Avoiding empty queries in tsearch - Mailing list pgsql-general

From Doug Cole
Subject Re: Avoiding empty queries in tsearch
Date
Msg-id 7b8d80330701151103g58a58083u7f3d37a934964c9d@mail.gmail.com
Whole thread Raw
In response to Avoiding empty queries in tsearch  ("Doug Cole" <doug@shackprices.com>)
Responses Re: Avoiding empty queries in tsearch  (Oleg Bartunov <oleg@sai.msu.su>)
List 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 by date:

Previous
From: "Albert"
Date:
Subject: Reserve a value in a serial type field
Next
From: Teodor Sigaev
Date:
Subject: Re: Avoiding empty queries in tsearch