Search Postgresql Archives

Re: Avoiding empty queries in tsearch

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux