Re: BUG #5102: Silent IN (list of strings) failure to detect syntax error when list is linewrapped

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-bugs(at)postgresql(dot)org>, "Geoff Tolley" <geoff(dot)tolley(at)yougov(dot)com>
Subject: Re: BUG #5102: Silent IN (list of strings) failure to detect syntax error when list is linewrapped
Date: 2009-10-08 15:12:03
Message-ID: 4ACDBAF3020000250002B73A@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Geoff Tolley" <geoff(dot)tolley(at)yougov(dot)com> wrote:

> postgres=# SELECT 'hello' WHERE '1' IN ('1'
> postgres(# '2');

Per the SQL standard, that is the same as

SELECT 'hello' WHERE '1' IN ('12');

I believe that's intended to make it easier to code long string
literals without creating query text which has long line lengths, but
they (understandably) don't require a minimum length for the string
fragments.

-Kevin

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2009-10-08 15:12:22 Re: BUG #5104: tsearch parser mislead
Previous Message Alvaro Herrera 2009-10-08 14:56:29 Re: BUG #5102: Silent IN (list of strings) failure to detect syntax error when list is linewrapped