Re: AT TIME ZONE and DST in UTC<->CET conversion

Tom Lane wrote:
> Gregory Stark <stark(at)enterprisedb(dot)com> writes:
> > ISTM this is the one that's wrong. "CET" is standard time, it, GMT+1.
>
> > If you want a timezone which switches between CET and CST automatically you
> > should use something like Europe/Paris.
>
> Well, actually he *is* using such a zone:
>
> regression=# select * from pg_timezone_names where name = 'CET';
> name | abbrev | utc_offset | is_dst
> ------+--------+------------+--------
> CET | CEST | 02:00:00 | t
> (1 row)
>
> But
>
> regression=# select * from pg_timezone_abbrevs where abbrev = 'CET';
> abbrev | utc_offset | is_dst
> --------+------------+--------
> CET | 01:00:00 | f
> (1 row)
>
> The problem is that one of these two statements is using the abbrev
> meaning and the other is using the timezone meaning.
>
> We don't have much control over the zone definition, so I'm thinking
> maybe the abbrev should be removed from the tznames lists. But that
> seems a bit sucky too. Does anyone have any idea if the zic folk would
> be responsive to a complaint that defining a timezone with the same
> name as an abbreviation is a bad idea?

Is this a TODO?

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +