Re: status of yet another timezone todo item - Mailing list pgsql-hackers

From Tom Lane
Subject Re: status of yet another timezone todo item
Date
Msg-id 24182.1153859098@sss.pgh.pa.us
Whole thread Raw
In response to status of yet another timezone todo item  (Joachim Wieland <joe@mcknight.de>)
List pgsql-hackers
Joachim Wieland <joe@mcknight.de> writes:
> what do people think about this TODO item:
>         o Merge hardwired timezone names with the TZ database; allow either
>           kind everywhere a TZ name is currently taken
> I think it is kind of done.

Not quite --- SET TIMEZONE doesn't take the abbreviations.

I'm not sure how important it is to accept SET TIME ZONE 'AKST'
given that such a thing is not going to have any DST awareness;
for most parts of the world, it's probably *wrong* to do this
rather than SET TIME ZONE 'America/Anchorage'.
But that was part of the original thought behind the TODO item.
Do we want to explicitly decide not to support that?

I'm not sure whether there are any other holes (I thought of
AT TIME ZONE, but it seems to work with both).
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Better name/syntax for "online" index creation
Next
From: Tom Lane
Date:
Subject: Re: On-disk bitmap index patch