Skip site navigation (1) Skip section navigation (2)

Re: Timezone fun (bugs and a request)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>
Cc: "Oliver Jowett" <oliver(at)opencloud(dot)com>,"Alvaro Herrera" <alvherre(at)dcc(dot)uchile(dot)cl>,"Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Timezone fun (bugs and a request)
Date: 2004-05-25 14:05:40
Message-ID: 22605.1085493940@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
"Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at> writes:
> It is common practice that + is East and - is West, no ?

The SQL standard says that.  The POSIX standard says the opposite.
Most of the Unixen I'm familiar with follow POSIX when choosing time
zone names.

The zic database is in itself a de facto standard (it's used verbatim
in glibc, I believe, and on several non-glibc platforms).  So I'm
rather hesitant to make any unilateral changes in it.  I would like to
think that we will be able to "just drop in" any updates that occur from
time to time in the zone database files.  Politicians being what they
are, you can be certain there will be changes to track.

Also, it's worth pointing out here that falling back to Etc/GMT+/-n
is intended to be just that, a last-ditch fallback that won't be seen
in normal practice.  We still need to do some more work on
identify_system_timezone() to make that happen outside North America,
but I would like to think that average users will never see these zones
except by deliberate selection.  So I think it's not worth getting
worked up about what the sign convention is.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Gaetano MendolaDate: 2004-05-25 15:17:57
Subject: Re: Optimizer bug??
Previous:From: Bruce MomjianDate: 2004-05-25 13:57:46
Subject: Re: Timezone fun (bugs and a request)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group