Setting time zone commands - Mailing list pgsql-bugs

From cnliou
Subject Setting time zone commands
Date
Msg-id 1070368820.14816.cnliou@so-net.net.tw
Whole thread Raw
Responses Re: Setting time zone commands  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Hi!

Seeing no comments on the same issue I raised in=20
pgsql-general list, I am posting it here.
The documentation (Appendix B.2. Date/Time Key Words) says=20
that the following SQL's are legal, but actually they are=20
not:

SET TIME ZONE TO '<any time zone abbreviation>'
(examples:
SET TIMEZONE TO 'NZDT';
SET TIMEZONE TO 'EST';
)

However, the following SQL's are accepted by postgres:

SET TIME ZONE TO 0
SET TIME ZONE TO 9
SET TIME ZONE TO -4

Regards,
CN

pgsql-bugs by date:

Previous
From: Martin Edlman
Date:
Subject: Re: Repeatedly breaking indexes - SOLVED
Next
From: Tom Lane
Date:
Subject: Re: Setting time zone commands