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
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
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";
14 -------------------------------
15 - Sun Apr 03 12:00:00 2005 CDT
18 SELECT timestamp with time zone '2005-04-02 12:00-07' + interval '24 hours' as "Apr 3, 13:00";
20 ------------------------------
21 Sun Apr 03 13:00:00 2005 CDT
24 -SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '1 day' as "Apr 2, 12:00";
26 -------------------------------
27 - Sat Apr 02 12:00:00 2005 CST
30 -SELECT timestamp with time zone '2005-04-03 12:00-06' - interval '24 hours' as "Apr 2, 11:00";
32 -------------------------------
33 - Sat Apr 02 11:00:00 2005 CST
37 SELECT timestamptz(date '1994-01-01', time '11:00') AS "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
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";