Re: bug: evil autoConcat when each string is on new line - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: bug: evil autoConcat when each string is on new line
Date
Msg-id 20190424124459.GA26812@alvherre.pgsql
Whole thread Raw
In response to bug: evil autoConcat when each string is on new line  (Jan Skydánek <jan.skydanek@betsys.com>)
Responses Re: bug: evil autoConcat when each string is on new line  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: bug: evil autoConcat when each string is on new line  (raf@raf.org)
List pgsql-bugs
On 2019-Apr-24, Jan Skydánek wrote:

> Works (definitely NOT expected):
> SELECT
> 'aaa'
> 'bbb'
> 'ccc'
> ; -- result is: 'aaabbbccc'
> 
> I really hope this behavior is not intentional.

Actually it's the SQL standard that defines that it must work in exactly
that way.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-bugs by date:

Previous
From: Vik Fearing
Date:
Subject: Re: bug: evil autoConcat when each string is on new line
Next
From: PG Bug reporting form
Date:
Subject: BUG #15777: Unexpected error in select from view with set-returning function and union