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(at)sigaev(dot)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(at)sigaev(dot)ru
> WWW:
http://www.sigaev.ru/