Re: Avoiding empty queries in tsearch

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/