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

From: "Sander Steffann" <s(dot)steffann(at)computel(dot)nl>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: [HACKERS] Anyone using "POSIX" time zone offset capability?
Date: 2006-10-17 13:28:26
Message-ID: 00f601c6f1f0$20859bf0$64c8a8c0@balefirehome
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi,

> "Sander Steffann" <s(dot)steffann(at)computel(dot)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 ...

Hmmmm. I hadn't thought of that, but then: with the changes you proposed
they would still get what they expect. Even though that notation would not
conform to the POSIX docs.

Still seems like a good idea :)
Sander

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-10-17 13:29:03 Re: Aother tablespace permission issue (was Re: Permission problem ...)
Previous Message Tom Lane 2006-10-17 13:23:25 Re: [HACKERS] Anyone using "POSIX" time zone offset capability?

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Kreen 2006-10-17 13:34:35 Re: Getting the type Oid in a CREATE TYPE output function
Previous Message Tom Lane 2006-10-17 13:23:25 Re: [HACKERS] Anyone using "POSIX" time zone offset capability?