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/
>