]>
Commit | Line | Data |
---|---|---|
23f835d4 | 1 | # |
2 | # an ugly hack to disable some "horology" tests,which fail if built | |
3 | # --with-system-tzdata and non-US /usr/share/zoneinfo/posixrules: | |
4 | # http://www.nabble.com/Beta2-%22horology%22-test-failure-on-non-US-zoneinfo-posixrules-td13691442.html | |
5 | # | |
6 | --- postgresql-8.3RC1/src/test/regress/expected/horology.out 2007-07-25 18:22:36.000000000 +0100 | |
7 | +++ postgresql-8.3.0/src/test/regress/expected/horology.out 2008-02-04 20:20:16.091518646 +0000 | |
8 | @@ -602,30 +602,12 @@ | |
9 | ||
10 | -- timestamp with time zone, interval arithmetic around DST change | |
11 | SET TIME ZONE 'CST7CDT'; | |
12 | -SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as "Apr 3, 12:00"; | |
13 | - Apr 3, 12:00 | |
14 | ------------------------------- | |
15 | - Sun Apr 03 12:00:00 2005 CDT | |
16 | -(1 row) | |
17 | - | |
18 | SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00"; | |
19 | Apr 3, 13:00 | |
20 | ------------------------------ | |
21 | Sun Apr 03 13:00:00 2005 CDT | |
22 | (1 row) | |
23 | ||
24 | -SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00"; | |
25 | - Apr 2, 12:00 | |
26 | ------------------------------- | |
27 | - Sat Apr 02 12:00:00 2005 CST | |
28 | -(1 row) | |
29 | - | |
30 | -SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as "Apr 2, 11:00"; | |
31 | - Apr 2, 11:00 | |
32 | ------------------------------- | |
33 | - Sat Apr 02 11:00:00 2005 CST | |
34 | -(1 row) | |
35 | - | |
36 | RESET TIME ZONE; | |
37 | SELECT timestamptz(date '1994-01-01', time '11:00') AS "Jan_01_1994_10am"; | |
38 | Jan_01_1994_10am | |
39 | --- postgresql-8.3RC1/src/test/regress/sql/horology.sql 2007-07-25 18:22:37.000000000 +0100 | |
40 | +++ postgresql-8.3.0/src/test/regress/sql/horology.sql 2008-02-04 20:20:18.091381199 +0000 | |
41 | @@ -114,10 +114,7 @@ | |
42 | ||
43 | -- timestamp with time zone, interval arithmetic around DST change | |
44 | SET TIME ZONE 'CST7CDT'; | |
45 | -SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '1 day' as "Apr 3, 12:00"; | |
46 | SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00"; | |
47 | -SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00"; | |
48 | -SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as "Apr 2, 11:00"; | |
49 | RESET TIME ZONE; | |
50 | ||
51 |