Timezone strangeness - Mailing list pgsql-hackers

From Rod Taylor
Subject Timezone strangeness
Date
Msg-id 1054748876.21969.82.camel@jester
Whole thread Raw
Responses Re: Timezone strangeness  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Postgres config file: autocommit = off
Next
From: Jan Wieck
Date:
Subject: Re: Compressing Fields?