Re: Bug?: Text after right paren in query is ignored - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: Bug?: Text after right paren in query is ignored
Date
Msg-id 20050930145840.GA7891@surnet.cl
Whole thread Raw
In response to Bug?: Text after right paren in query is ignored  (Steve Peterson <steve@zpfe.com>)
Responses Re: Bug?: Text after right paren in query is ignored  (Steve Peterson <steve@zpfe.com>)
List pgsql-bugs
On Thu, Sep 29, 2005 at 10:04:04PM -0500, Steve Peterson wrote:
> Is this a bug or some artifact of the SQL language that I've never
> seen before?
>
> SELECT v_id
> FROM table
> WHERE col = 'V')
> AND blah
>
> executes without errors, ignoring the closing paren and everything
> thereafter.

Not here.  How are you executing that query, exactly?

--
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 17.7", W 73º 14' 26.8"
"Some men are heterosexual, and some are bisexual, and some
men don't think about sex at all... they become lawyers" (Woody Allen)

pgsql-bugs by date:

Previous
From: Steve Peterson
Date:
Subject: Bug?: Text after right paren in query is ignored
Next
From: "Till Toenges"
Date:
Subject: BUG #1928: Postgresql is terminated by signal 10 (bus error) when using prepared statements