Re: Is this a bug ? - Mailing list pgsql-general

From Ron
Subject Re: Is this a bug ?
Date
Msg-id a2122ac3-2aaf-d69a-bdc8-e9bf0c7b5b55@gmail.com
Whole thread Raw
In response to Re: Is this a bug ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Is this a bug ?
List pgsql-general
On 10/23/19 11:00 AM, Tom Lane wrote:
> Ron <ronljohnsonjr@gmail.com> writes:
>> On 10/23/19 10:51 AM, Geoff Winkless wrote:
>>> Two string constants that are only separated by whitespace with at
>>> least one newline are concatenated and effectively treated as if the
>>> string had been written as one constant.
>> Then -- since the 'e' is separated from 'd' by a comma, the result should be
>> "4", not "3".
> No, because your command is equivalent to
>
>      select count(*) from bugtest where fld1 in ('a','b','cd','e');
>
> 'cd' does not match any of the table rows, so 3 is the correct answer.

Yes, that's my mistake.

>> No doubt: it's a bug, no matter what the Pg devs say.
> Complain to the SQL standards committee, not us.

As much as I hate to say it, MSFT was right to ignore this bug in the standard.


-- 
Angular momentum makes the world go 'round.



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Is this a bug ?
Next
From: "David G. Johnston"
Date:
Subject: Re: Lookup Primary Key of Foreign Server's Table