Postgres Pro
Downloads
Home   >   mailing lists

Re: Comma Comma Comma 8601 - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: Comma Comma Comma 8601
Date
Msg-id 519633D0-8DD9-497C-B575-85B893FD9575@justatheory.com
Whole thread Raw
In response to Re: Comma Comma Comma 8601  ("David E. Wheeler" <david@justatheory.com>)
List pgsql-hackers
Tree view 
On Jul 23, 2013, at 6:24 PM, David E. Wheeler <david@justatheory.com> wrote:

> I kind of suspect not, since this fails:
>
> david=# select '12:24:53 654'::time;
> ERROR:  invalid input syntax for type time: "12:24:53 654"
> LINE 1: select '12:24:53 654'::time;
>               ^
>
> I would have guessed that the time parser gets to a state where it knows it is dealing with a ISO-8601-style time.
ButI have not looked at the code, of course. 

I added this to the To Dos so it won’t get lost.
 https://wiki.postgresql.org/wiki/Todo#Dates_and_Times

Best,

David

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])
Next
From: Josh Berkus
Date:
Subject: Re: File-per-GUC WAS: Re: ALTER SYSTEM SET command to change postgresql.conf parameters (RE: Proposal for Allow postgresql.conf values to be changed via SQL [review])