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