Re: PDT but not WEST

On Sep 29, 2011, at 10:50 AM, Tom Lane wrote:

> Christophe Pettus <xof@thebuild.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@thebuild.com