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

From Tom Lane
Subject Re: Comma Comma Comma 8601
Date
Msg-id 28725.1374535079@sss.pgh.pa.us
Whole thread Raw
In response to Comma Comma Comma 8601  ("David E. Wheeler" <david@justatheory.com>)
Responses Re: Comma Comma Comma 8601
List pgsql-hackers
"David E. Wheeler" <david@justatheory.com> writes:
> But I do wonder if the comma should be allowed for fractional seconds,
> since the spec says it is preferred (and often used in Javaland, I'm
> told). As in "14:30:50,232". Thoughts?

Does that create any ambiguities against formats we already support?
I'm worried about examples like this one:

select 'monday, july 22, 22:30 2013'::timestamptz;     timestamptz       
------------------------2013-07-22 22:30:00-04
(1 row)

Right now I'm pretty sure that the datetime parser treats comma as a
noise symbol.  If that stops being true, we're likely to break some
applications out there (admittedly, possibly rather strange ones,
but still ...)
        regards, tom lane



pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: [9.4 CF 1] The Commitfest Slacker List
Next
From: Andres Freund
Date:
Subject: Re: [COMMITTERS] pgsql: Add support for REFRESH MATERIALIZED VIEW CONCURRENTLY.