Re: [HACKERS] Timezone strangeness

2003-06-05 Thread Rod Taylor
On Wed, 2003-06-04 at 14:55, Christopher Browne wrote: > Rod Taylor wrote: > > Note the first timezone change is taken, but the second one is ignored. > > rbt=3D# set time zone est; > > SET > > rbt=3D# select * from t; > > col > > > > 2003-06-03 18:30:25+00 > > (

Re: [HACKERS] Timezone strangeness

2003-06-05 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: > Note the first timezone change is taken, but the second one is ignored. Neither of them are being taken, I think. In CVS tip I get ERROR: unrecognized timezone name "udt" ERROR: unrecognized timezone name "est" but until recently we made

[HACKERS] Timezone strangeness

2003-06-05 Thread Rod Taylor
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=#