On Wed, Oct 23, 2019 at 9:03 PM Peter J. Holzer <hjp-pgsql@xxxxxx> 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
