Re: Is this a bug ?

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@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 |
>> +-------------+
> 
> 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@aklaver.com