Thread: status of yet another timezone todo item

Hi,

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
currentlytaken
 

I think it is kind of done. The hardwired timezone names are no longer
hardwired and the "America/New_York" syntax is valid in timestamps and
times as well.


Joachim

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