Re: Avoiding empty queries in tsearch

[Teodor Sigaev <teodor@xxxxxxxxx>]

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@xxxxxxxxx
                                                   WWW: http://www.sigaev.ru/