Search Postgresql Archives

Re: Checking is TSearch2 query is valid

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

 



Tom Lane wrote:
> Benjamin Arai <me@xxxxxxxxxxxxxxxx> writes:
> > Is there a specific exception code for:
> > ERROR:  no operand in tsearch query: "("
> 
> regression=# \set VERBOSITY verbose
> regression=# select to_tsquery('(');
> ERROR:  42601: no operand in tsearch query: "("
> LOCATION:  gettoken_query, tsquery.c:163
> 
> Seems to be "SYNTAX_ERROR".

Hmm, maybe we should be displaying the textual name of the SQLSTATE
somehow.

-- 
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"El día que dejes de cambiar dejarás de vivir"

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[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