1
1
--
2
- --TIMESPAN
2
+ --INTERVAL
3
3
--
4
- CREATE TABLETIMESPAN_TBL (f1timespan );
5
- INSERT INTOTIMESPAN_TBL (f1) VALUES ('@ 1 minute');
6
- INSERT INTOTIMESPAN_TBL (f1) VALUES ('@ 5 hour');
7
- INSERT INTOTIMESPAN_TBL (f1) VALUES ('@ 10 day');
8
- INSERT INTOTIMESPAN_TBL (f1) VALUES ('@ 34 year');
9
- INSERT INTOTIMESPAN_TBL (f1) VALUES ('@ 3 months');
10
- INSERT INTOTIMESPAN_TBL (f1) VALUES ('@ 14 seconds ago');
11
- INSERT INTOTIMESPAN_TBL (f1) VALUES ('1 day 2 hours 3 minutes 4 seconds');
12
- INSERT INTOTIMESPAN_TBL (f1) VALUES ('6 years');
13
- INSERT INTOTIMESPAN_TBL (f1) VALUES ('5 months');
14
- INSERT INTOTIMESPAN_TBL (f1) VALUES ('5 months 12 hours');
15
- -- badly formattedtimespan
16
- INSERT INTOTIMESPAN_TBL (f1) VALUES ('badly formattedtimespan ');
17
- ERROR: Badtimespan external representation 'badly formattedtimespan '
18
- INSERT INTOTIMESPAN_TBL (f1) VALUES ('@ 30 eons ago');
19
- ERROR: Badtimespan external representation '@ 30 eons ago'
20
- -- testtimespan operators
21
- SELECT '' AS ten,TIMESPAN_TBL .*;
4
+ CREATE TABLEINTERVAL_TBL (f1interval );
5
+ INSERT INTOINTERVAL_TBL (f1) VALUES ('@ 1 minute');
6
+ INSERT INTOINTERVAL_TBL (f1) VALUES ('@ 5 hour');
7
+ INSERT INTOINTERVAL_TBL (f1) VALUES ('@ 10 day');
8
+ INSERT INTOINTERVAL_TBL (f1) VALUES ('@ 34 year');
9
+ INSERT INTOINTERVAL_TBL (f1) VALUES ('@ 3 months');
10
+ INSERT INTOINTERVAL_TBL (f1) VALUES ('@ 14 seconds ago');
11
+ INSERT INTOINTERVAL_TBL (f1) VALUES ('1 day 2 hours 3 minutes 4 seconds');
12
+ INSERT INTOINTERVAL_TBL (f1) VALUES ('6 years');
13
+ INSERT INTOINTERVAL_TBL (f1) VALUES ('5 months');
14
+ INSERT INTOINTERVAL_TBL (f1) VALUES ('5 months 12 hours');
15
+ -- badly formattedinterval
16
+ INSERT INTOINTERVAL_TBL (f1) VALUES ('badly formattedinterval ');
17
+ ERROR: Badinterval external representation 'badly formattedinterval '
18
+ INSERT INTOINTERVAL_TBL (f1) VALUES ('@ 30 eons ago');
19
+ ERROR: Badinterval external representation '@ 30 eons ago'
20
+ -- testinterval operators
21
+ SELECT '' AS ten,INTERVAL_TBL .*;
22
22
ten | f1
23
23
-----+-------------------------------
24
24
| @ 1 min
@@ -33,8 +33,8 @@ SELECT '' AS ten, TIMESPAN_TBL.*;
33
33
| @ 5 mons 12 hours
34
34
(10 rows)
35
35
36
- SELECT '' AS nine,TIMESPAN_TBL .*
37
- WHERETIMESPAN_TBL .f1 <>timespan '@ 10 days';
36
+ SELECT '' AS nine,INTERVAL_TBL .*
37
+ WHEREINTERVAL_TBL .f1 <>interval '@ 10 days';
38
38
nine | f1
39
39
------+-------------------------------
40
40
| @ 1 min
@@ -48,33 +48,33 @@ SELECT '' AS nine, TIMESPAN_TBL.*
48
48
| @ 5 mons 12 hours
49
49
(9 rows)
50
50
51
- SELECT '' AS three,TIMESPAN_TBL .*
52
- WHERETIMESPAN_TBL .f1 <=timespan '@ 5 hours';
51
+ SELECT '' AS three,INTERVAL_TBL .*
52
+ WHEREINTERVAL_TBL .f1 <=interval '@ 5 hours';
53
53
three | f1
54
54
-------+---------------
55
55
| @ 1 min
56
56
| @ 5 hours
57
57
| @ 14 secs ago
58
58
(3 rows)
59
59
60
- SELECT '' AS three,TIMESPAN_TBL .*
61
- WHERETIMESPAN_TBL .f1 <timespan '@ 1 day';
60
+ SELECT '' AS three,INTERVAL_TBL .*
61
+ WHEREINTERVAL_TBL .f1 <interval '@ 1 day';
62
62
three | f1
63
63
-------+---------------
64
64
| @ 1 min
65
65
| @ 5 hours
66
66
| @ 14 secs ago
67
67
(3 rows)
68
68
69
- SELECT '' AS one,TIMESPAN_TBL .*
70
- WHERETIMESPAN_TBL .f1 =timespan '@ 34 years';
69
+ SELECT '' AS one,INTERVAL_TBL .*
70
+ WHEREINTERVAL_TBL .f1 =interval '@ 34 years';
71
71
one | f1
72
72
-----+------------
73
73
| @ 34 years
74
74
(1 row)
75
75
76
- SELECT '' AS five,TIMESPAN_TBL .*
77
- WHERETIMESPAN_TBL .f1 >=timespan '@ 1 month';
76
+ SELECT '' AS five,INTERVAL_TBL .*
77
+ WHEREINTERVAL_TBL .f1 >=interval '@ 1 month';
78
78
five | f1
79
79
------+-------------------
80
80
| @ 34 years
@@ -84,8 +84,8 @@ SELECT '' AS five, TIMESPAN_TBL.*
84
84
| @ 5 mons 12 hours
85
85
(5 rows)
86
86
87
- SELECT '' AS nine,TIMESPAN_TBL .*
88
- WHERETIMESPAN_TBL .f1 >timespan '@ 3 seconds ago';
87
+ SELECT '' AS nine,INTERVAL_TBL .*
88
+ WHEREINTERVAL_TBL .f1 >interval '@ 3 seconds ago';
89
89
nine | f1
90
90
------+-------------------------------
91
91
| @ 1 min
@@ -100,7 +100,7 @@ SELECT '' AS nine, TIMESPAN_TBL.*
100
100
(9 rows)
101
101
102
102
SELECT '' AS fortyfive, r1.*, r2.*
103
- FROMTIMESPAN_TBL r1,TIMESPAN_TBL r2
103
+ FROMINTERVAL_TBL r1,INTERVAL_TBL r2
104
104
WHERE r1.f1 > r2.f1
105
105
ORDER BY r1.f1, r2.f1;
106
106
fortyfive | f1 | f1