Tom Lane wrote:
> Gregory Stark <stark@enterprisedb.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@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +