>>>regression=# set timezone to 'US/Arizona';
>>>SET
>>>regression=# select now();
>>>now
>>>-------------------------------
>>>2004-10-25 10:52:49.441559-07
>
>
>>Wow! When did that get fixed? How do I keep track of this stuff if you
>>guys keep fixing it? ;-)
That's worked for ages. What doesn't work is this:
usatest=# select current_timestamp at time zone 'US/Arizona';
ERROR: time zone "us/arizona" not recognized
Chris