Re: [GENERAL] Anyone using "POSIX" time zone offset capability?

Поиск
Список
Период
Сортировка
От Sander Steffann
Тема Re: [GENERAL] Anyone using "POSIX" time zone offset capability?
Дата
Msg-id 00cd01c6f1e7$0e68b3c0$64c8a8c0@balefirehome
обсуждение исходный текст
Ответ на Re: [GENERAL] Anyone using "POSIX" time zone offset capability?  ("Brandon Aiken" <BAiken@winemantech.com>)
Ответы Re: [GENERAL] Anyone using "POSIX" time zone offset capability?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

> The POSIX timezone notation as understood by the zic code includes
> the possibility of
>
> zoneabbrev[+-]hh[:mm[:ss]]
>
> but the meaning is that hh:mm:ss *is* the offset from GMT, and
> zoneabbrev is being defined as the abbreviation for that offset.
> What the datetime.c code is doing is trying to find the zoneabbrev
> in a built-in timezone table, and then adding the two together.
> This is simply wacko.

I think that if anyone has ever tried to use this notation they would have
noticed this misinterpretation of the specs.

> Given where the code stands now, I think the best solution is to
> rip out DecodePosixTimezone and instead pass the syntax off to the
> zic code (which can handle it via tzparse()).  Since the datetime
> input parser is ultimately only interested in the GMT offset value,
> this would mean that the zoneabbrev part would become a noise word.

Sounds like a good idea to me.
Sander



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: Is python 2.5 supported?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] Anyone using "POSIX" time zone offset capability?