Re: Is this a bug ?

On Wed, 23 Oct 2019 at 17:20, Geoff Winkless <pgsqladmin@geoff.dj> 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.

As an aside, Postgres isn't the only DB to follow the standard here.

mysql> select 'hello'
    -> ' there';
+-------------+
| hello       |
+-------------+
| hello there |
+-------------+

Geoff