Skip site navigation (1) Skip section navigation (2)

Re: Bug?: Text after right paren in query is ignored

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Steve Peterson <steve(at)zpfe(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Bug?: Text after right paren in query is ignored
Date: 2005-09-30 14:58:40
Message-ID: 20050930145840.GA7891@surnet.cl (view raw or flat)
Thread:
Lists: 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)

In response to

Responses

pgsql-bugs by date

Next:From: Michael RauDate: 2005-09-30 18:06:11
Subject: BUG #1929: Successful COPY fails with less records in CSV file
Previous:From: Tom LaneDate: 2005-09-30 14:31:01
Subject: Re: BUG #1926: /etc/init.d/postgresql - script version 7.4.5

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group