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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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