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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
