Re: timestamptz parsing bug? - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: timestamptz parsing bug?
Date
Msg-id 56ACB5A7-DAEB-431B-91E3-10CAC6F8F2BF@kineticode.com
Whole thread Raw
In response to Re: timestamptz parsing bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: timestamptz parsing bug?
List pgsql-hackers
On Aug 29, 2011, at 12:30 PM, Tom Lane wrote:

>> When it gets to the timezone "America/Chicago" at the end, this is
>> handled in the DTK_DATE case, because of the "/". But because ptype is
>> still set, it is expecting this to be an ISO time, so it errors out.
>
> Do we actually *want* to support this?  The "T" is supposed to mean that
> the string is strictly ISO-conformant, no?

I didn't realize that appending a time zone was not conformant, but apparently it's not.
 http://en.wikipedia.org/wiki/ISO_8601#Time_zone_designators

Only appending a "Z" or an offset seems to be legal. Interesting.

David



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: timestamptz parsing bug?
Next
From: Andrew Dunstan
Date:
Subject: Re: timestamptz parsing bug?