Search Postgresql Archives

Re: Is this a bug ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 10/23/19 11:00 AM, Tom Lane wrote:
Ron <ronljohnsonjr@xxxxxxxxx> 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.





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux