From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Christophe Pettus <xof(at)thebuild(dot)com>, pgsql-general list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PDT but not WEST |
Date: | 2011-09-29 18:44:55 |
Message-ID: | 4E84BCA7.1030403@pinpointresearch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 09/29/2011 10:50 AM, Tom Lane wrote:
> Christophe Pettus<xof(at)thebuild(dot)com> writes:
>> I am baffled. Both PDT and WEST appear as valid timezone abbreviations, and each have unique values, but:
> Where do you see WEST as a valid timezone abbrevation? It's not listed
> in the "Default" abbreviation list. (Perhaps it should be, since there
> don't seem to be any places that don't consider it GMT+1 summer time.)
>
> regards, tom lane
>
select * from pg_timezone_names where abbrev = 'WEST' ;
name | abbrev | utc_offset | is_dst
------------------------+--------+------------+--------
Portugal | WEST | 01:00:00 | t
posix/Portugal | WEST | 01:00:00 | t
posix/WET | WEST | 01:00:00 | t
posix/Europe/Lisbon | WEST | 01:00:00 | t
posix/Atlantic/Canary | WEST | 01:00:00 | t
posix/Atlantic/Faeroe | WEST | 01:00:00 | t
posix/Atlantic/Madeira | WEST | 01:00:00 | t
posix/Atlantic/Faroe | WEST | 01:00:00 | t
WET | WEST | 01:00:00 | t
Europe/Lisbon | WEST | 01:00:00 | t
Atlantic/Canary | WEST | 01:00:00 | t
Atlantic/Faeroe | WEST | 01:00:00 | t
Atlantic/Madeira | WEST | 01:00:00 | t
Atlantic/Faroe | WEST | 01:00:00 | t
(14 rows)
It's interesting that there are (in my install of 9.1):
1174 distinct timezone names (all records are unique) in pg_timezone_names.
181 distinct abbreviations in pg_timezone_names
189 distinct timezone abbreviations (all unique abbreviations) in
pg_timezone_abbrevs.
But 61 abbreviations that appear in pg_timezone_names do not have a
corresponding entry in pg_timezone_abbrevs and 69 abbreviations in
pg_timezone_abbrevs that don't appear in pg_timezone_names.
There are 56 records and 3 different offsets in pg_timezone_names for
the abbreviation 'CST'.
I try to use timezone names instead of abbreviations wherever possible.
Cheers,
Steve
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2011-09-29 18:48:06 | Re: PDT but not WEST |
Previous Message | Christophe Pettus | 2011-09-29 18:11:52 | Re: PDT but not WEST |