On Jul 23, 2013, at 1:17 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 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 ...)
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. But
Ihave not looked at the code, of course.
David