Oops - just to clarify I accidentally copied too many INSERTs into the email. The result of the first SELECT is correct compared to the INSERTs that I did. I copied the INSERTs and CREATE TABLE as-is from timetz.sql
Chris > -----Original Message----- > From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED]] > Sent: Thursday, 13 February 2003 11:08 AM > To: Hackers > Cc: Tom Lane > Subject: horology and time failures on freebsd/alpha > > > I'm still getting failure, but it gets weirder: > > regression=# drop table timetz_tbl; > DROP TABLE > regression=# CREATE TABLE TIMETZ_TBL (f1 time(2) with time zone); > > INSERT INTO TIMETZ_TBL VALUES ('00:01 PDT'); > CREATE TABLE > regression=# > regression=# INSERT INTO TIMETZ_TBL VALUES ('00:01 PDT'); > INSERT INTO TIMETZ_TBL VALUES ('01:00 PDT'); > INSERT INTO TIMETZ_TBL VALUES ('02:03 PDT'); > INSERT INTO TIMETZ_TBL VALUES ('07:07 PST'); > INSERT 154307 1 > regression=# INSERT INTO TIMETZ_TBL VALUES ('01:00 PDT'); > INSERT INTO TIMETZ_TBL VALUES ('02:03 PDT'); > INSERT INTO TIMETZ_TBL VALUES ('07:07 PST'); > INSERT INTO TIMETZ_TBL VALUES ('08:08 EDT'); > INSERT INTO TIMETZ_TBL VALUES ('11:59 PDT'); > INSERT 154308 1 > regression=# INSERT INTO TIMETZ_TBL VALUES ('02:03 PDT'); > INSERT INTO TIMETZ_TBL VALUES ('07:07 PST'); > INSERT INTO TIMETZ_TBL VALUES ('08:08 EDT'); > INSERT INTO TIMETZ_TBL VALUES ('11:59 PDT'); > INSERT INTO TIMETZ_TBL VALUES ('12:00 PDT'); > INSERT INTO TIMETZ_TBL VALUES ('12:01 PDT'); > INSERT 154309 1 > regression=# INSERT INTO TIMETZ_TBL VALUES ('07:07 PST'); > INSERT INTO TIMETZ_TBL VALUES ('08:08 EDT'); > INSERT INTO TIMETZ_TBL VALUES ('11:59 PDT'); > INSERT INTO TIMETZ_TBL VALUES ('12:00 PDT'); > INSERT INTO TIMETZ_TBL VALUES ('12:01 PDT'); > INSERT INTO TIMETZ_TBL VALUES ('23:59 PDT'); > INSERT INTO TIMETZ_TBL VALUES ('11:59:59.99 PM PDT'); > INSERT 154310 1 > regression=# INSERT INTO TIMETZ_TBL VALUES ('08:08 EDT'); > INSERT 154311 1 > regression=# INSERT INTO TIMETZ_TBL VALUES ('11:59 PDT'); > INSERT 154312 1 > regression=# INSERT INTO TIMETZ_TBL VALUES ('12:00 PDT'); > INSERT 154313 1 > regression=# INSERT INTO TIMETZ_TBL VALUES ('12:01 PDT'); > INSERT 154314 1 > regression=# INSERT INTO TIMETZ_TBL VALUES ('23:59 PDT'); > INSERT 154315 1 > regression=# INSERT INTO TIMETZ_TBL VALUES ('11:59:59.99 PM PDT'); > INSERT 154316 1 > regression=# SELECT f1 AS "Time TZ" FROM TIMETZ_TBL; > Time TZ > ---------------- > 00:01:00-07 > 01:00:00-07 > 02:03:00-07 > 07:07:00-08 > 08:08:00-04 > 11:59:00-07 > 12:00:00-07 > 12:01:00-07 > 23:59:00-07 > 23:59:59.99-07 > (10 rows) > > -- Now run EXACTLY the same query again... > > regression=# SELECT f1 AS "Time TZ" FROM TIMETZ_TBL; > Time TZ > ---------------- > 00:00:00-07 > 00:00:00-07 > 00:00:00-07 > 00:00:00-08 > 00:00:00-04 > 00:00:00-07 > 00:00:00-07 > 00:00:00-07 > 00:00:00-07 > 00:00:59.99-07 > > What the heck!!?!?!?! The SELECT statement has somehow edited > the data in the table or something??? From this point forward, > the table is all stuffed... > > Chris > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
