Re: bug: evil autoConcat when each string is on new line

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Jan Skydánek <jan(dot)skydanek(at)betsys(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: bug: evil autoConcat when each string is on new line
Date: 2019-04-24 12:44:59
Message-ID: 20190424124459.GA26812@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

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