Re: timestamptz parsing bug?

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: timestamptz parsing bug?
Дата
Msg-id 56ACB5A7-DAEB-431B-91E3-10CAC6F8F2BF@kineticode.com
обсуждение исходный текст
Ответ на Re: timestamptz parsing bug?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: timestamptz parsing bug?  (Andrew Dunstan <andrew@dunslane.net>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: timestamptz parsing bug?
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: timestamptz parsing bug?