On Wed, May 24, 2006 at 09:13:42PM -0400, Tom Lane wrote:
> The zic database doesn't seem to have a problem with using the same
> abbreviations to mean many different things. We could look to it for
> information, or maybe even use its classification of timezone groups,
> but I don't think it can solve the problem for us.
>
> I think you may be thinking of yet a separate TODO item, which is to
> be able to use the zic timezone names in timestamptz input, viz
> '2006-05-24 21:11 Americas/New_York'::timestamptz
> But names like 'IST' or 'CDT' are not zic timezone names, they just
> represent specific offsets from UTC.
Well, the zic database does contain information about the
abbreviations, so we would be able to build a list of them. I think the
right solution is probably fix the above first (allow full zic
timezones in timestamps) and then setup the CST/CEST/etc as a list of
aliases users can customise...
Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.