Joachim Wieland <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
