Re: Checking is TSearch2 query is valid

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Benjamin Arai <me(at)benjaminarai(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Checking is TSearch2 query is valid
Date: 2007-09-10 13:39:46
Message-ID: 3403.1189431586@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Benjamin Arai <me(at)benjaminarai(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-09-10 13:45:55 Re: audit sql queries
Previous Message Albe Laurenz 2007-09-10 13:08:38 Re: arrays of foreign keys