Re: Is this a bug ? - Mailing list pgsql-general

From Geoff Winkless
Subject Re: Is this a bug ?
Date
Msg-id CAEzk6ffCOE06qJg7GaKhn_9kq4i6nfOte2_C4vW3U6iz1L_ayg@mail.gmail.com
Whole thread Raw
In response to Re: Is this a bug ?  (Geoff Winkless <pgsqladmin@geoff.dj>)
Responses Re: Is this a bug ?
List pgsql-general
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



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Is this a bug ?
Next
From: Ron
Date:
Subject: Re: Is this a bug ?