horology and time failures on freebsd/alpha
От | Christopher Kings-Lynne |
---|---|
Тема | horology and time failures on freebsd/alpha |
Дата | |
Msg-id | GNELIHDDFBOCMGBFGEFOKEIHCFAA.chriskl@familyhealth.com.au обсуждение исходный текст |
Ответы |
Re: horology and time failures on freebsd/alpha
Re: horology and time failures on freebsd/alpha |
Список | pgsql-hackers |
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-0701:00:00-0702:03:00-0707:07:00-0808:08:00-0411:59:00-0712:00:00-0712:01:00-0723:59:00-0723: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-0700:00:00-0700:00:00-0700:00:00-0800:00:00-0400:00:00-0700:00:00-0700:00:00-0700:00:00-0700: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
В списке pgsql-hackers по дате отправления: