From: | Christophe Pettus <xof(at)thebuild(dot)com> |
---|---|
To: | pgsql-general list <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: PDT but not WEST |
Date: | 2011-09-29 18:11:52 |
Message-ID: | D0E97864-048C-464E-92A0-0A8ECDFEC18D@thebuild.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sep 29, 2011, at 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?
Voila, "Western Europe Summer Time":
test=# select * from pg_timezone_names where abbrev='WEST';
name | abbrev | utc_offset | is_dst
------------------+--------+------------+--------
Atlantic/Canary | WEST | 01:00:00 | t
Atlantic/Faeroe | WEST | 01:00:00 | t
Atlantic/Faroe | WEST | 01:00:00 | t
Atlantic/Madeira | WEST | 01:00:00 | t
Europe/Lisbon | WEST | 01:00:00 | t
Portugal | WEST | 01:00:00 | t
WET | WEST | 01:00:00 | t
(7 rows)
--
-- Christophe Pettus
xof(at)thebuild(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Crawford | 2011-09-29 18:44:55 | Re: PDT but not WEST |
Previous Message | Tom Lane | 2011-09-29 17:50:18 | Re: PDT but not WEST |