On Sep 29, 2011, at 10:50 AM, Tom Lane wrote:
> Christophe Pettus <[email protected]> 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
[email protected]
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
