Re: [GENERAL] Anyone using "POSIX" time zone offset capability? - Mailing list pgsql-hackers

From Sander Steffann
Subject Re: [GENERAL] Anyone using "POSIX" time zone offset capability?
Date
Msg-id 00cd01c6f1e7$0e68b3c0$64c8a8c0@balefirehome
Whole thread Raw
In response to Re: [GENERAL] Anyone using "POSIX" time zone offset capability?  ("Brandon Aiken" <BAiken@winemantech.com>)
Responses Re: [GENERAL] Anyone using "POSIX" time zone offset capability?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Is python 2.5 supported?
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Anyone using "POSIX" time zone offset capability?