From: | yangtao <yangtaoyours(at)126(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | timestamptz test failed by postgresql 6.5.0 |
Date: | 2021-01-04 05:52:01 |
Message-ID: | 59c4bbda.277f.176cbf3cda7.Coremail.yangtaoyours@126.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Recently, I compile the Postgresql 9.6.0 on Linux by myself. However, I meet one problem about the timestamptz.sql test case.
The expected timestamptz.out is different from the result of timestamptz.out for ime zone America/Caracas and
America/Santiago
Part of expected timestamptz.out :
DROP TABLE TIMESTAMPTZ_TST;
-- test timestamptz constructors
set TimeZone to 'America/Santiago';
-- numeric timezone
SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33);
make_timestamptz
---------------------------------
Sun Jul 15 08:15:55.33 1973 CLT
(1 row)
SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33, '+2');
make_timestamptz
---------------------------------
Sun Jul 15 02:15:55.33 1973 CLT
Part of the result timestamptz.out :
DROP TABLE TIMESTAMPTZ_TST;
-- test timestamptz constructors
set TimeZone to 'America/Santiago';
-- numeric timezone
SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33);
make_timestamptz
---------------------------------
Sun Jul 15 08:15:55.33 1973 -04
(1 row)
SELECT make_timestamptz(1973, 07, 15, 08, 15, 55.33, '+2');
make_timestamptz
---------------------------------
Sun Jul 15 02:15:55.33 1973 -04
I don't why the timezone in the output "CLT" becomes "-04" in the output. Could anyone please give me some idea to find the trouble cause?
Thanks!
Best Regards!
Tao
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2021-01-04 06:07:39 | Re: timestamptz test failed by postgresql 6.5.0 |
Previous Message | Jack Orenstein | 2021-01-04 04:41:08 | Re: Crashing on insert to GIN index |