Note the first timezone change is taken, but the second one is ignored.
rbt=# select * from t; col
------------------------2003-06-03 14:30:25-04
(1 row)
rbt=# set time zone udt;
SET
rbt=# select * from t; col
------------------------2003-06-03 18:30:25+00
(1 row)
rbt=# set time zone est;
SET
rbt=# select * from t; col
------------------------2003-06-03 18:30:25+00
(1 row)
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc