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

From Tom Lane
Subject Re: [HACKERS] Anyone using "POSIX" time zone offset capability?
Date
Msg-id 16394.1161091405@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Anyone using "POSIX" time zone offset capability?  ("Sander Steffann" <s.steffann@computel.nl>)
List pgsql-general
"Sander Steffann" <s.steffann@computel.nl> writes:
>> 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.

Well, it'd work without surprise for the case of "GMT+-n", which is
undoubtedly the most common case ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Harald Armin Massa"
Date:
Subject: Re: Can we convert from Postgres to Oracle !!???
Next
From: AgentM
Date:
Subject: Re: A query planner that learns