Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit67ef699

Browse files
committed
Update horology-no-DST-before-1970.out (tested on HPUX), plus an extrapolated horology-solaris-1947.out
(needs verification).
1 parent15c7931 commit67ef699

File tree

2 files changed

+48
-46
lines changed

2 files changed

+48
-46
lines changed

‎src/test/regress/expected/horology-no-DST-before-1970.out

Lines changed: 24 additions & 23 deletions
Original file line numberDiff line numberDiff line change
@@ -264,22 +264,22 @@ SELECT date '2001-02-03' + time with time zone '04:05:06 UTC' AS "Date + Time UT
264264
(1 row)
265265

266266
SELECT date '1991-02-03' + interval '2 years' AS "Add Two Years";
267-
Add Two Years
268-
------------------------------
269-
Wed Feb 03 00:00:00 1993 PST
267+
Add Two Years
268+
--------------------------
269+
Wed Feb 03 00:00:00 1993
270270
(1 row)
271271

272272
SELECT date '2001-12-13' - interval '2 years' AS "Subtract Two Years";
273-
Subtract Two Years
274-
------------------------------
275-
Mon Dec 13 00:00:00 1999 PST
273+
Subtract Two Years
274+
--------------------------
275+
Mon Dec 13 00:00:00 1999
276276
(1 row)
277277

278278
-- subtract time from date should not make sense; use interval instead
279279
SELECT date '1991-02-03' - time '04:05:06' AS "Subtract Time";
280-
Subtract Time
281-
------------------------------
282-
Sat Feb 02 19:54:54 1991 PST
280+
Subtract Time
281+
--------------------------
282+
Sat Feb 02 19:54:54 1991
283283
(1 row)
284284

285285
SELECT date '1991-02-03' - time with time zone '04:05:06 UTC' AS "Subtract Time UTC";
@@ -406,7 +406,7 @@ SELECT '' AS "64", d1 + interval '1 year' AS one_year FROM TIMESTAMP_TBL;
406406
| Sat Feb 14 17:32:01 1998
407407
| Sun Feb 15 17:32:01 1998
408408
| Mon Feb 16 17:32:01 1998
409-
| Thu Feb 16 17:32 0096 BC
409+
| Thu Feb 16 17:32:01 0096 BC
410410
| Sun Feb 16 17:32:01 0098
411411
| Fri Feb 16 17:32:01 0598
412412
| Wed Feb 16 17:32:01 1098
@@ -475,7 +475,7 @@ SELECT '' AS "64", d1 - interval '1 year' AS one_year FROM TIMESTAMP_TBL;
475475
| Wed Feb 14 17:32:01 1996
476476
| Thu Feb 15 17:32:01 1996
477477
| Fri Feb 16 17:32:01 1996
478-
| Mon Feb 16 17:32 0098 BC
478+
| Mon Feb 16 17:32:01 0098 BC
479479
| Thu Feb 16 17:32:01 0096
480480
| Tue Feb 16 17:32:01 0596
481481
| Sun Feb 16 17:32:01 1096
@@ -622,7 +622,7 @@ SELECT '' AS "64", d1 + interval '1 year' AS one_year FROM TIMESTAMPTZ_TBL;
622622
| Sat Feb 14 17:32:01 1998 PST
623623
| Sun Feb 15 17:32:01 1998 PST
624624
| Mon Feb 16 17:32:01 1998 PST
625-
| Thu Feb 16 17:32 0096 BC
625+
| Thu Feb 16 17:32:01 0096 BC
626626
| Sun Feb 16 17:32:01 0098
627627
| Fri Feb 16 17:32:01 0598
628628
| Wed Feb 16 17:32:01 1098
@@ -691,7 +691,7 @@ SELECT '' AS "64", d1 - interval '1 year' AS one_year FROM TIMESTAMPTZ_TBL;
691691
| Wed Feb 14 17:32:01 1996 PST
692692
| Thu Feb 15 17:32:01 1996 PST
693693
| Fri Feb 16 17:32:01 1996 PST
694-
| Mon Feb 16 17:32 0098 BC
694+
| Mon Feb 16 17:32:01 0098 BC
695695
| Thu Feb 16 17:32:01 0096
696696
| Tue Feb 16 17:32:01 0596
697697
| Sun Feb 16 17:32:01 1096
@@ -1519,7 +1519,7 @@ SELECT (time '00:00', interval '1 hour')
15191519
f
15201520
(1 row)
15211521

1522-
CREATE TABLE TEMP_TIMESTAMP (f1 timestamp);
1522+
CREATE TABLE TEMP_TIMESTAMP (f1 timestamp with time zone);
15231523
-- get some candidate input values
15241524
INSERT INTO TEMP_TIMESTAMP (f1)
15251525
SELECT d1 FROM TIMESTAMP_TBL
@@ -1883,8 +1883,9 @@ SELECT '' AS "160", d.f1 AS "timestamp", t.f1 AS "interval", d.f1 - t.f1 AS minu
18831883
| Sat Sep 22 18:19:20 2001 PDT | @ 14 secs ago | Sat Sep 22 18:19:34 2001 PDT
18841884
(160 rows)
18851885

1886-
SELECT '' AS "16", d.f1 AS "timestamp", timestamp '1980-01-06 00:00 GMT' AS gpstime_zero,
1887-
d.f1 - timestamp '1980-01-06 00:00 GMT' AS difference
1886+
SELECT '' AS "16", d.f1 AS "timestamp",
1887+
timestamp with time zone '1980-01-06 00:00 GMT' AS gpstime_zero,
1888+
d.f1 - timestamp with time zone '1980-01-06 00:00 GMT' AS difference
18881889
FROM TEMP_TIMESTAMP d
18891890
ORDER BY difference;
18901891
16 | timestamp | gpstime_zero | difference
@@ -2305,7 +2306,7 @@ SELECT '' AS two, d1 AS "timestamp", abstime(d1) AS abstime
23052306

23062307
SELECT '' AS three, f1 as abstime, cast(f1 as timestamp) AS "timestamp"
23072308
FROM ABSTIME_TBL WHERE NOT isfinite(f1);
2308-
ERROR: Unable to convert abstime 'invalid' totimestamptz
2309+
ERROR: Unable to convert abstime 'invalid' totimestamp
23092310
SELECT '' AS ten, f1 AS interval, reltime(f1) AS reltime
23102311
FROM INTERVAL_TBL;
23112312
ten | interval | reltime
@@ -2385,7 +2386,7 @@ SELECT '' AS "64", d1 AS us_postgres FROM TIMESTAMP_TBL;
23852386
| Fri Feb 14 17:32:01 1997
23862387
| Sat Feb 15 17:32:01 1997
23872388
| Sun Feb 16 17:32:01 1997
2388-
| Tue Feb 16 17:32 0097 BC
2389+
| Tue Feb 16 17:32:01 0097 BC
23892390
| Sat Feb 16 17:32:01 0097
23902391
| Thu Feb 16 17:32:01 0597
23912392
| Tue Feb 16 17:32:01 1097
@@ -2467,7 +2468,7 @@ SELECT '' AS "64", d1 AS us_iso FROM TIMESTAMP_TBL;
24672468
| 1997-02-14 17:32:01
24682469
| 1997-02-15 17:32:01
24692470
| 1997-02-16 17:32:01
2470-
| 0097-02-16 17:32 BC
2471+
| 0097-02-16 17:32:01 BC
24712472
| 0097-02-16 17:32:01
24722473
| 0597-02-16 17:32:01
24732474
| 1097-02-16 17:32:01
@@ -2551,7 +2552,7 @@ SELECT '' AS "64", d1 AS us_sql FROM TIMESTAMP_TBL;
25512552
| 02/14/1997 17:32:01
25522553
| 02/15/1997 17:32:01
25532554
| 02/16/1997 17:32:01
2554-
| 02/16/0097 17:32 BC
2555+
| 02/16/0097 17:32:01 BC
25552556
| 02/16/0097 17:32:01
25562557
| 02/16/0597 17:32:01
25572558
| 02/16/1097 17:32:01
@@ -2642,7 +2643,7 @@ SELECT '' AS "65", d1 AS european_postgres FROM TIMESTAMP_TBL;
26422643
| Fri 14 Feb 17:32:01 1997
26432644
| Sat 15 Feb 17:32:01 1997
26442645
| Sun 16 Feb 17:32:01 1997
2645-
| Tue 16 Feb 17:32 0097 BC
2646+
| Tue 16 Feb 17:32:01 0097 BC
26462647
| Sat 16 Feb 17:32:01 0097
26472648
| Thu 16 Feb 17:32:01 0597
26482649
| Tue 16 Feb 17:32:01 1097
@@ -2727,7 +2728,7 @@ SELECT '' AS "65", d1 AS european_iso FROM TIMESTAMP_TBL;
27272728
| 1997-02-14 17:32:01
27282729
| 1997-02-15 17:32:01
27292730
| 1997-02-16 17:32:01
2730-
| 0097-02-16 17:32 BC
2731+
| 0097-02-16 17:32:01 BC
27312732
| 0097-02-16 17:32:01
27322733
| 0597-02-16 17:32:01
27332734
| 1097-02-16 17:32:01
@@ -2812,7 +2813,7 @@ SELECT '' AS "65", d1 AS european_sql FROM TIMESTAMP_TBL;
28122813
| 14/02/1997 17:32:01
28132814
| 15/02/1997 17:32:01
28142815
| 16/02/1997 17:32:01
2815-
| 16/02/0097 17:32 BC
2816+
| 16/02/0097 17:32:01 BC
28162817
| 16/02/0097 17:32:01
28172818
| 16/02/0597 17:32:01
28182819
| 16/02/1097 17:32:01

‎src/test/regress/expected/horology-solaris-1947.out

Lines changed: 24 additions & 23 deletions
Original file line numberDiff line numberDiff line change
@@ -264,22 +264,22 @@ SELECT date '2001-02-03' + time with time zone '04:05:06 UTC' AS "Date + Time UT
264264
(1 row)
265265

266266
SELECT date '1991-02-03' + interval '2 years' AS "Add Two Years";
267-
Add Two Years
268-
------------------------------
269-
Wed Feb 03 00:00:00 1993 PST
267+
Add Two Years
268+
--------------------------
269+
Wed Feb 03 00:00:00 1993
270270
(1 row)
271271

272272
SELECT date '2001-12-13' - interval '2 years' AS "Subtract Two Years";
273-
Subtract Two Years
274-
------------------------------
275-
Mon Dec 13 00:00:00 1999 PST
273+
Subtract Two Years
274+
--------------------------
275+
Mon Dec 13 00:00:00 1999
276276
(1 row)
277277

278278
-- subtract time from date should not make sense; use interval instead
279279
SELECT date '1991-02-03' - time '04:05:06' AS "Subtract Time";
280-
Subtract Time
281-
------------------------------
282-
Sat Feb 02 19:54:54 1991 PST
280+
Subtract Time
281+
--------------------------
282+
Sat Feb 02 19:54:54 1991
283283
(1 row)
284284

285285
SELECT date '1991-02-03' - time with time zone '04:05:06 UTC' AS "Subtract Time UTC";
@@ -406,7 +406,7 @@ SELECT '' AS "64", d1 + interval '1 year' AS one_year FROM TIMESTAMP_TBL;
406406
| Sat Feb 14 17:32:01 1998
407407
| Sun Feb 15 17:32:01 1998
408408
| Mon Feb 16 17:32:01 1998
409-
| Thu Feb 16 17:32 0096 BC
409+
| Thu Feb 16 17:32:01 0096 BC
410410
| Sun Feb 16 17:32:01 0098
411411
| Fri Feb 16 17:32:01 0598
412412
| Wed Feb 16 17:32:01 1098
@@ -475,7 +475,7 @@ SELECT '' AS "64", d1 - interval '1 year' AS one_year FROM TIMESTAMP_TBL;
475475
| Wed Feb 14 17:32:01 1996
476476
| Thu Feb 15 17:32:01 1996
477477
| Fri Feb 16 17:32:01 1996
478-
| Mon Feb 16 17:32 0098 BC
478+
| Mon Feb 16 17:32:01 0098 BC
479479
| Thu Feb 16 17:32:01 0096
480480
| Tue Feb 16 17:32:01 0596
481481
| Sun Feb 16 17:32:01 1096
@@ -622,7 +622,7 @@ SELECT '' AS "64", d1 + interval '1 year' AS one_year FROM TIMESTAMPTZ_TBL;
622622
| Sat Feb 14 17:32:01 1998 PST
623623
| Sun Feb 15 17:32:01 1998 PST
624624
| Mon Feb 16 17:32:01 1998 PST
625-
| Thu Feb 16 17:32 0096 BC
625+
| Thu Feb 16 17:32:01 0096 BC
626626
| Sun Feb 16 17:32:01 0098
627627
| Fri Feb 16 17:32:01 0598
628628
| Wed Feb 16 17:32:01 1098
@@ -691,7 +691,7 @@ SELECT '' AS "64", d1 - interval '1 year' AS one_year FROM TIMESTAMPTZ_TBL;
691691
| Wed Feb 14 17:32:01 1996 PST
692692
| Thu Feb 15 17:32:01 1996 PST
693693
| Fri Feb 16 17:32:01 1996 PST
694-
| Mon Feb 16 17:32 0098 BC
694+
| Mon Feb 16 17:32:01 0098 BC
695695
| Thu Feb 16 17:32:01 0096
696696
| Tue Feb 16 17:32:01 0596
697697
| Sun Feb 16 17:32:01 1096
@@ -1519,7 +1519,7 @@ SELECT (time '00:00', interval '1 hour')
15191519
f
15201520
(1 row)
15211521

1522-
CREATE TABLE TEMP_TIMESTAMP (f1 timestamp);
1522+
CREATE TABLE TEMP_TIMESTAMP (f1 timestamp with time zone);
15231523
-- get some candidate input values
15241524
INSERT INTO TEMP_TIMESTAMP (f1)
15251525
SELECT d1 FROM TIMESTAMP_TBL
@@ -1883,8 +1883,9 @@ SELECT '' AS "160", d.f1 AS "timestamp", t.f1 AS "interval", d.f1 - t.f1 AS minu
18831883
| Sat Sep 22 18:19:20 2001 PDT | @ 14 secs ago | Sat Sep 22 18:19:34 2001 PDT
18841884
(160 rows)
18851885

1886-
SELECT '' AS "16", d.f1 AS "timestamp", timestamp '1980-01-06 00:00 GMT' AS gpstime_zero,
1887-
d.f1 - timestamp '1980-01-06 00:00 GMT' AS difference
1886+
SELECT '' AS "16", d.f1 AS "timestamp",
1887+
timestamp with time zone '1980-01-06 00:00 GMT' AS gpstime_zero,
1888+
d.f1 - timestamp with time zone '1980-01-06 00:00 GMT' AS difference
18881889
FROM TEMP_TIMESTAMP d
18891890
ORDER BY difference;
18901891
16 | timestamp | gpstime_zero | difference
@@ -2305,7 +2306,7 @@ SELECT '' AS two, d1 AS "timestamp", abstime(d1) AS abstime
23052306

23062307
SELECT '' AS three, f1 as abstime, cast(f1 as timestamp) AS "timestamp"
23072308
FROM ABSTIME_TBL WHERE NOT isfinite(f1);
2308-
ERROR: Unable to convert abstime 'invalid' totimestamptz
2309+
ERROR: Unable to convert abstime 'invalid' totimestamp
23092310
SELECT '' AS ten, f1 AS interval, reltime(f1) AS reltime
23102311
FROM INTERVAL_TBL;
23112312
ten | interval | reltime
@@ -2385,7 +2386,7 @@ SELECT '' AS "64", d1 AS us_postgres FROM TIMESTAMP_TBL;
23852386
| Fri Feb 14 17:32:01 1997
23862387
| Sat Feb 15 17:32:01 1997
23872388
| Sun Feb 16 17:32:01 1997
2388-
| Tue Feb 16 17:32 0097 BC
2389+
| Tue Feb 16 17:32:01 0097 BC
23892390
| Sat Feb 16 17:32:01 0097
23902391
| Thu Feb 16 17:32:01 0597
23912392
| Tue Feb 16 17:32:01 1097
@@ -2467,7 +2468,7 @@ SELECT '' AS "64", d1 AS us_iso FROM TIMESTAMP_TBL;
24672468
| 1997-02-14 17:32:01
24682469
| 1997-02-15 17:32:01
24692470
| 1997-02-16 17:32:01
2470-
| 0097-02-16 17:32 BC
2471+
| 0097-02-16 17:32:01 BC
24712472
| 0097-02-16 17:32:01
24722473
| 0597-02-16 17:32:01
24732474
| 1097-02-16 17:32:01
@@ -2551,7 +2552,7 @@ SELECT '' AS "64", d1 AS us_sql FROM TIMESTAMP_TBL;
25512552
| 02/14/1997 17:32:01
25522553
| 02/15/1997 17:32:01
25532554
| 02/16/1997 17:32:01
2554-
| 02/16/0097 17:32 BC
2555+
| 02/16/0097 17:32:01 BC
25552556
| 02/16/0097 17:32:01
25562557
| 02/16/0597 17:32:01
25572558
| 02/16/1097 17:32:01
@@ -2642,7 +2643,7 @@ SELECT '' AS "65", d1 AS european_postgres FROM TIMESTAMP_TBL;
26422643
| Fri 14 Feb 17:32:01 1997
26432644
| Sat 15 Feb 17:32:01 1997
26442645
| Sun 16 Feb 17:32:01 1997
2645-
| Tue 16 Feb 17:32 0097 BC
2646+
| Tue 16 Feb 17:32:01 0097 BC
26462647
| Sat 16 Feb 17:32:01 0097
26472648
| Thu 16 Feb 17:32:01 0597
26482649
| Tue 16 Feb 17:32:01 1097
@@ -2727,7 +2728,7 @@ SELECT '' AS "65", d1 AS european_iso FROM TIMESTAMP_TBL;
27272728
| 1997-02-14 17:32:01
27282729
| 1997-02-15 17:32:01
27292730
| 1997-02-16 17:32:01
2730-
| 0097-02-16 17:32 BC
2731+
| 0097-02-16 17:32:01 BC
27312732
| 0097-02-16 17:32:01
27322733
| 0597-02-16 17:32:01
27332734
| 1097-02-16 17:32:01
@@ -2812,7 +2813,7 @@ SELECT '' AS "65", d1 AS european_sql FROM TIMESTAMP_TBL;
28122813
| 14/02/1997 17:32:01
28132814
| 15/02/1997 17:32:01
28142815
| 16/02/1997 17:32:01
2815-
| 16/02/0097 17:32 BC
2816+
| 16/02/0097 17:32:01 BC
28162817
| 16/02/0097 17:32:01
28172818
| 16/02/0597 17:32:01
28182819
| 16/02/1097 17:32:01

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp