On Wed, Oct 23, 2019 at 9:03 PM Peter J. Holzer <hjp-pgsql(at)hjp(dot)at> wrote:
>
> On 2019-10-23 17:20:07 +0100, Geoff Winkless wrote:
> > For what it's worth, I can see a value to having
> >
> > SELECT 'this is quite a long string'
> > 'which I've joined together '
> > 'across multiple lines';
> >
> > although the advantage of it vs using a concat operator is slim.
>
> True. However, concatenation of string literals by juxtaposition isn't
> specific to SQL. Two other well known languages where this works (even
> without a newline) are C and Python.
And C++ as well