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(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc