Postgres Pro
Downloads
Home   >   mailing lists

Re: Avoiding empty queries in tsearch - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: Avoiding empty queries in tsearch
Date
Msg-id 45ABAC13.6090907@sigaev.ru
Whole thread Raw
In response to Avoiding empty queries in tsearch  ("Doug Cole" <doug@shackprices.com>)
Responses Re: Avoiding empty queries in tsearch  ("Doug Cole" <doug@shackprices.com>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Unpredicatable behavior of volatile functions used
Next
From: "Ardian Xharra"
Date:
Subject: Re: Why the data changes it's value by itself!