Re: Checking is TSearch2 query is valid

Benjamin Arai <me@benjaminarai.com> 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".

            regards, tom lane