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

Commitefcc757

Browse files
committed
Clean up date_part tests a bit
Some tests for timestamp and timestamptz were in the date.sql testfile. Move them to their appropriate files, or drop tests cases thatwere already present there.
1 parentf37fec8 commitefcc757

File tree

6 files changed

+147
-235
lines changed

6 files changed

+147
-235
lines changed

‎src/test/regress/expected/date.out

Lines changed: 2 additions & 78 deletions
Original file line numberDiff line numberDiff line change
@@ -971,18 +971,6 @@ SELECT EXTRACT(EPOCH FROM DATE '1970-01-01'); -- 0
971971
0
972972
(1 row)
973973

974-
SELECT EXTRACT(EPOCH FROM TIMESTAMP '1970-01-01'); -- 0
975-
date_part
976-
-----------
977-
0
978-
(1 row)
979-
980-
SELECT EXTRACT(EPOCH FROM TIMESTAMPTZ '1970-01-01+00'); -- 0
981-
date_part
982-
-----------
983-
0
984-
(1 row)
985-
986974
--
987975
-- century
988976
--
@@ -1137,22 +1125,6 @@ SELECT EXTRACT(DECADE FROM DATE '0012-12-31 BC'); -- -2
11371125
-2
11381126
(1 row)
11391127

1140-
--
1141-
-- some other types:
1142-
--
1143-
-- on a timestamp.
1144-
SELECT EXTRACT(CENTURY FROM NOW())>=21 AS True; -- true
1145-
true
1146-
------
1147-
t
1148-
(1 row)
1149-
1150-
SELECT EXTRACT(CENTURY FROM TIMESTAMP '1970-03-20 04:30:00.00000'); -- 20
1151-
date_part
1152-
-----------
1153-
20
1154-
(1 row)
1155-
11561128
--
11571129
-- all possible fields
11581130
--
@@ -1370,7 +1342,7 @@ select isfinite('infinity'::date), isfinite('-infinity'::date), isfinite('today'
13701342
(1 row)
13711343

13721344
--
1373-
-- oscillating fields from non-finite date/timestamptz:
1345+
-- oscillating fields from non-finite date:
13741346
--
13751347
SELECT EXTRACT(HOUR FROM DATE 'infinity'); -- NULL
13761348
date_part
@@ -1384,30 +1356,6 @@ SELECT EXTRACT(HOUR FROM DATE '-infinity'); -- NULL
13841356

13851357
(1 row)
13861358

1387-
SELECT EXTRACT(HOUR FROM TIMESTAMP 'infinity'); -- NULL
1388-
date_part
1389-
-----------
1390-
1391-
(1 row)
1392-
1393-
SELECT EXTRACT(HOUR FROM TIMESTAMP '-infinity'); -- NULL
1394-
date_part
1395-
-----------
1396-
1397-
(1 row)
1398-
1399-
SELECT EXTRACT(HOUR FROM TIMESTAMPTZ 'infinity'); -- NULL
1400-
date_part
1401-
-----------
1402-
1403-
(1 row)
1404-
1405-
SELECT EXTRACT(HOUR FROM TIMESTAMPTZ '-infinity'); -- NULL
1406-
date_part
1407-
-----------
1408-
1409-
(1 row)
1410-
14111359
-- all possible fields
14121360
SELECT EXTRACT(MICROSECONDS FROM DATE 'infinity'); -- NULL
14131361
date_part
@@ -1500,7 +1448,7 @@ SELECT EXTRACT(TIMEZONE_H FROM DATE 'infinity'); -- NULL
15001448
(1 row)
15011449

15021450
--
1503-
-- monotonic fields from non-finite date/timestamptz:
1451+
-- monotonic fields from non-finite date:
15041452
--
15051453
SELECT EXTRACT(EPOCH FROM DATE 'infinity'); -- Infinity
15061454
date_part
@@ -1514,30 +1462,6 @@ SELECT EXTRACT(EPOCH FROM DATE '-infinity'); -- -Infinity
15141462
-Infinity
15151463
(1 row)
15161464

1517-
SELECT EXTRACT(EPOCH FROM TIMESTAMP 'infinity'); -- Infinity
1518-
date_part
1519-
-----------
1520-
Infinity
1521-
(1 row)
1522-
1523-
SELECT EXTRACT(EPOCH FROM TIMESTAMP '-infinity'); -- -Infinity
1524-
date_part
1525-
-----------
1526-
-Infinity
1527-
(1 row)
1528-
1529-
SELECT EXTRACT(EPOCH FROM TIMESTAMPTZ 'infinity'); -- Infinity
1530-
date_part
1531-
-----------
1532-
Infinity
1533-
(1 row)
1534-
1535-
SELECT EXTRACT(EPOCH FROM TIMESTAMPTZ '-infinity'); -- -Infinity
1536-
date_part
1537-
-----------
1538-
-Infinity
1539-
(1 row)
1540-
15411465
-- all possible fields
15421466
SELECT EXTRACT(YEAR FROM DATE 'infinity'); -- Infinity
15431467
date_part

‎src/test/regress/expected/timestamp.out

Lines changed: 69 additions & 68 deletions
Original file line numberDiff line numberDiff line change
@@ -931,75 +931,76 @@ SELECT d1 as "timestamp",
931931
date_part( 'decade', d1) AS decade,
932932
date_part( 'century', d1) AS century,
933933
date_part( 'millennium', d1) AS millennium,
934-
round(date_part( 'julian', d1)) AS julian
934+
round(date_part( 'julian', d1)) AS julian,
935+
date_part( 'epoch', d1) AS epoch
935936
FROM TIMESTAMP_TBL;
936-
timestamp | decade | century | millennium | julian
937-
-----------------------------+-----------+-----------+------------+-----------
938-
-infinity | -Infinity | -Infinity | -Infinity | -Infinity
939-
infinity | Infinity | Infinity | Infinity | Infinity
940-
Thu Jan 01 00:00:00 1970 | 197 | 20 | 2 | 2440588
941-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
942-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
943-
Mon Feb 10 17:32:02 1997 | 199 | 20 | 2 | 2450491
944-
Mon Feb 10 17:32:01.4 1997 | 199 | 20 | 2 | 2450491
945-
Mon Feb 10 17:32:01.5 1997 | 199 | 20 | 2 | 2450491
946-
Mon Feb 10 17:32:01.6 1997 | 199 | 20 | 2 | 2450491
947-
Thu Jan 02 00:00:00 1997 | 199 | 20 | 2 | 2450451
948-
Thu Jan 02 03:04:05 1997 | 199 | 20 | 2 | 2450451
949-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
950-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
951-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
952-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
953-
Tue Jun 10 17:32:01 1997 | 199 | 20 | 2 | 2450611
954-
Sat Sep 22 18:19:20 2001 | 200 | 21 | 3 | 2452176
955-
Wed Mar 15 08:14:01 2000 | 200 | 20 | 2 | 2451619
956-
Wed Mar 15 13:14:02 2000 | 200 | 20 | 2 | 2451620
957-
Wed Mar 15 12:14:03 2000 | 200 | 20 | 2 | 2451620
958-
Wed Mar 15 03:14:04 2000 | 200 | 20 | 2 | 2451619
959-
Wed Mar 15 02:14:05 2000 | 200 | 20 | 2 | 2451619
960-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
961-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
962-
Mon Feb 10 17:32:00 1997 | 199 | 20 | 2 | 2450491
963-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
964-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
965-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
966-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
967-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
968-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
969-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
970-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
971-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
972-
Tue Jun 10 18:32:01 1997 | 199 | 20 | 2 | 2450611
973-
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491
974-
Tue Feb 11 17:32:01 1997 | 199 | 20 | 2 | 2450492
975-
Wed Feb 12 17:32:01 1997 | 199 | 20 | 2 | 2450493
976-
Thu Feb 13 17:32:01 1997 | 199 | 20 | 2 | 2450494
977-
Fri Feb 14 17:32:01 1997 | 199 | 20 | 2 | 2450495
978-
Sat Feb 15 17:32:01 1997 | 199 | 20 | 2 | 2450496
979-
Sun Feb 16 17:32:01 1997 | 199 | 20 | 2 | 2450497
980-
Tue Feb 16 17:32:01 0097 BC | -10 | -1 | -1 | 1686043
981-
Sat Feb 16 17:32:01 0097 | 9 | 1 | 1 | 1756537
982-
Thu Feb 16 17:32:01 0597 | 59 | 6 | 1 | 1939158
983-
Tue Feb 16 17:32:01 1097 | 109 | 11 | 2 | 2121779
984-
Sat Feb 16 17:32:01 1697 | 169 | 17 | 2 | 2340925
985-
Thu Feb 16 17:32:01 1797 | 179 | 18 | 2 | 2377449
986-
Tue Feb 16 17:32:01 1897 | 189 | 19 | 2 | 2413973
987-
Sun Feb 16 17:32:01 1997 | 199 | 20 | 2 | 2450497
988-
Sat Feb 16 17:32:01 2097 | 209 | 21 | 3 | 2487022
989-
Wed Feb 28 17:32:01 1996 | 199 | 20 | 2 | 2450143
990-
Thu Feb 29 17:32:01 1996 | 199 | 20 | 2 | 2450144
991-
Fri Mar 01 17:32:01 1996 | 199 | 20 | 2 | 2450145
992-
Mon Dec 30 17:32:01 1996 | 199 | 20 | 2 | 2450449
993-
Tue Dec 31 17:32:01 1996 | 199 | 20 | 2 | 2450450
994-
Wed Jan 01 17:32:01 1997 | 199 | 20 | 2 | 2450451
995-
Fri Feb 28 17:32:01 1997 | 199 | 20 | 2 | 2450509
996-
Sat Mar 01 17:32:01 1997 | 199 | 20 | 2 | 2450510
997-
Tue Dec 30 17:32:01 1997 | 199 | 20 | 2 | 2450814
998-
Wed Dec 31 17:32:01 1997 | 199 | 20 | 2 | 2450815
999-
Fri Dec 31 17:32:01 1999 | 199 | 20 | 2 | 2451545
1000-
Sat Jan 01 17:32:01 2000 | 200 | 20 | 2 | 2451546
1001-
Sun Dec 31 17:32:01 2000 | 200 | 20 | 2 | 2451911
1002-
Mon Jan 01 17:32:01 2001 | 200 | 21 | 3 | 2451912
937+
timestamp | decade | century | millennium | julian| epoch
938+
-----------------------------+-----------+-----------+------------+-----------+--------------
939+
-infinity | -Infinity | -Infinity | -Infinity | -Infinity | -Infinity
940+
infinity | Infinity | Infinity | Infinity | Infinity | Infinity
941+
Thu Jan 01 00:00:00 1970 | 197 | 20 | 2 | 2440588 | 0
942+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
943+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
944+
Mon Feb 10 17:32:02 1997 | 199 | 20 | 2 | 2450491 | 855595922
945+
Mon Feb 10 17:32:01.4 1997 | 199 | 20 | 2 | 2450491 | 855595921.4
946+
Mon Feb 10 17:32:01.5 1997 | 199 | 20 | 2 | 2450491 | 855595921.5
947+
Mon Feb 10 17:32:01.6 1997 | 199 | 20 | 2 | 2450491 | 855595921.6
948+
Thu Jan 02 00:00:00 1997 | 199 | 20 | 2 | 2450451 | 852163200
949+
Thu Jan 02 03:04:05 1997 | 199 | 20 | 2 | 2450451 | 852174245
950+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
951+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
952+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
953+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
954+
Tue Jun 10 17:32:01 1997 | 199 | 20 | 2 | 2450611 | 865963921
955+
Sat Sep 22 18:19:20 2001 | 200 | 21 | 3 | 2452176 | 1001182760
956+
Wed Mar 15 08:14:01 2000 | 200 | 20 | 2 | 2451619 | 953108041
957+
Wed Mar 15 13:14:02 2000 | 200 | 20 | 2 | 2451620 | 953126042
958+
Wed Mar 15 12:14:03 2000 | 200 | 20 | 2 | 2451620 | 953122443
959+
Wed Mar 15 03:14:04 2000 | 200 | 20 | 2 | 2451619 | 953090044
960+
Wed Mar 15 02:14:05 2000 | 200 | 20 | 2 | 2451619 | 953086445
961+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
962+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
963+
Mon Feb 10 17:32:00 1997 | 199 | 20 | 2 | 2450491 | 855595920
964+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
965+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
966+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
967+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
968+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
969+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
970+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
971+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
972+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
973+
Tue Jun 10 18:32:01 1997 | 199 | 20 | 2 | 2450611 | 865967521
974+
Mon Feb 10 17:32:01 1997 | 199 | 20 | 2 | 2450491 | 855595921
975+
Tue Feb 11 17:32:01 1997 | 199 | 20 | 2 | 2450492 | 855682321
976+
Wed Feb 12 17:32:01 1997 | 199 | 20 | 2 | 2450493 | 855768721
977+
Thu Feb 13 17:32:01 1997 | 199 | 20 | 2 | 2450494 | 855855121
978+
Fri Feb 14 17:32:01 1997 | 199 | 20 | 2 | 2450495 | 855941521
979+
Sat Feb 15 17:32:01 1997 | 199 | 20 | 2 | 2450496 | 856027921
980+
Sun Feb 16 17:32:01 1997 | 199 | 20 | 2 | 2450497 | 856114321
981+
Tue Feb 16 17:32:01 0097 BC | -10 | -1 | -1 | 1686043 | -65192711279
982+
Sat Feb 16 17:32:01 0097 | 9 | 1 | 1 | 1756537 | -59102029679
983+
Thu Feb 16 17:32:01 0597 | 59 | 6 | 1 | 1939158 | -43323575279
984+
Tue Feb 16 17:32:01 1097 | 109 | 11 | 2 | 2121779 | -27545120879
985+
Sat Feb 16 17:32:01 1697 | 169 | 17 | 2 | 2340925 | -8610906479
986+
Thu Feb 16 17:32:01 1797 | 179 | 18 | 2 | 2377449 | -5455232879
987+
Tue Feb 16 17:32:01 1897 | 189 | 19 | 2 | 2413973 | -2299559279
988+
Sun Feb 16 17:32:01 1997 | 199 | 20 | 2 | 2450497 | 856114321
989+
Sat Feb 16 17:32:01 2097 | 209 | 21 | 3 | 2487022 | 4011874321
990+
Wed Feb 28 17:32:01 1996 | 199 | 20 | 2 | 2450143 | 825528721
991+
Thu Feb 29 17:32:01 1996 | 199 | 20 | 2 | 2450144 | 825615121
992+
Fri Mar 01 17:32:01 1996 | 199 | 20 | 2 | 2450145 | 825701521
993+
Mon Dec 30 17:32:01 1996 | 199 | 20 | 2 | 2450449 | 851967121
994+
Tue Dec 31 17:32:01 1996 | 199 | 20 | 2 | 2450450 | 852053521
995+
Wed Jan 01 17:32:01 1997 | 199 | 20 | 2 | 2450451 | 852139921
996+
Fri Feb 28 17:32:01 1997 | 199 | 20 | 2 | 2450509 | 857151121
997+
Sat Mar 01 17:32:01 1997 | 199 | 20 | 2 | 2450510 | 857237521
998+
Tue Dec 30 17:32:01 1997 | 199 | 20 | 2 | 2450814 | 883503121
999+
Wed Dec 31 17:32:01 1997 | 199 | 20 | 2 | 2450815 | 883589521
1000+
Fri Dec 31 17:32:01 1999 | 199 | 20 | 2 | 2451545 | 946661521
1001+
Sat Jan 01 17:32:01 2000 | 200 | 20 | 2 | 2451546 | 946747921
1002+
Sun Dec 31 17:32:01 2000 | 200 | 20 | 2 | 2451911 | 978283921
1003+
Mon Jan 01 17:32:01 2001 | 200 | 21 | 3 | 2451912 | 978370321
10031004
(65 rows)
10041005

10051006
-- TO_CHAR()

0 commit comments

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