Re: Allowed timezone values

> Also, JST doesn't work anymore, but JST9 does.  JST has no daylight
> savings time values, so it is a valid timezone setting, while EST is
> not:
> 
>     test=> set timezone = 'JST';
>     ERROR:  unrecognized time zone name: "JST"
> 
>     test=> set timezone = 'JST9';
>     SET

Note that JST and JST9 are completely different timezone. I'm not
sure this is correct or not...

test=# select '2005-10-14 18:00' at time zone 'JST';     timezone       
---------------------2005-10-15 08:00:00
(1 row)

test=# select '2005-10-14 18:00' at time zone 'JST9';     timezone       
---------------------2005-10-14 14:00:00
(1 row)
--
SRA OSS, Inc. Japan
Tatsuo Ishii