On 10/23/19 9:30 AM, Ron wrote:
On 10/23/19 11:27 AM, Geoff Winkless wrote:
On Wed, 23 Oct 2019 at 17:20, Geoff Winkless <pgsqladmin@xxxxxxxx> 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 |
+-------------+
This is the kind of weird stuff that we mocked mysql for.
This too would have been roundly mocked if discovered in mysql:
postgres=# select to_date('2018150X','YYYYMMDD');
to_date
------------
2019-03-03
(1 row)
As of v10 it does not work in Postgres either:
test_(postgres)# select version();
version
----------------------------------------------------------------------------------------------------------------------------
PostgreSQL 11.5 on x86_64-pc-linux-gnu, compiled by gcc (SUSE Linux)
7.4.1 20190424 [gcc-7-branch revision 270538], 64-bit
(1 row)
test_(postgres)# select to_date('2018150X','YYYYMMDD');
ERROR: date/time field value out of range: "2018150X"
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
