aboutsummaryrefslogtreecommitdiff
path: root/src/test/regress/expected/abstime.out
blob: 4ccff322d3fe7bdeee9b4efaad7a824b5e189b84 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
QUERY: CREATE TABLE ABSTIME_TBL (f1 abstime);
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Jan 14, 1973 03:14:21');
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Mon May  1 00:30:30 1995'::abstime);
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('epoch'::abstime);
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('current'::abstime);
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('infinity'::abstime);
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('-infinity'::abstime);
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('May 10, 1947 23:59:12');
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Feb 35, 1946 10:00:00');
WARN:Bad abstime external representation 'Feb 35, 1946 10:00:00'
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Feb 28, 1984 25:08:10');
WARN:Bad abstime external representation 'Feb 28, 1984 25:08:10'
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('bad date format');
WARN:Bad abstime external representation 'bad date format'
QUERY: INSERT INTO ABSTIME_TBL (f1) VALUES ('Jun 10, 1843');
QUERY: SELECT '' AS eight, ABSTIME_TBL.*;
eight|f1                          
-----+----------------------------
     |Sun Jan 14 03:14:21 1973 PST
     |Mon May 01 00:30:30 1995 PDT
     |epoch                       
     |current                     
     |infinity                    
     |-infinity                   
     |Sat May 10 23:59:12 1947 PST
     |invalid                     
(8 rows)

QUERY: SELECT '' AS six, ABSTIME_TBL.*
   WHERE ABSTIME_TBL.f1 < 'Jun 30, 2001'::abstime;
six|f1                          
---+----------------------------
   |Sun Jan 14 03:14:21 1973 PST
   |Mon May 01 00:30:30 1995 PDT
   |epoch                       
   |current                     
   |-infinity                   
   |Sat May 10 23:59:12 1947 PST
(6 rows)

QUERY: SELECT '' AS six, ABSTIME_TBL.*
   WHERE ABSTIME_TBL.f1 > '-infinity'::abstime;
six|f1                          
---+----------------------------
   |Sun Jan 14 03:14:21 1973 PST
   |Mon May 01 00:30:30 1995 PDT
   |epoch                       
   |current                     
   |infinity                    
   |Sat May 10 23:59:12 1947 PST
(6 rows)

QUERY: SELECT '' AS six, ABSTIME_TBL.*
   WHERE 'May 10, 1947 23:59:12'::abstime <> ABSTIME_TBL.f1;
six|f1                          
---+----------------------------
   |Sun Jan 14 03:14:21 1973 PST
   |Mon May 01 00:30:30 1995 PDT
   |epoch                       
   |current                     
   |infinity                    
   |-infinity                   
(6 rows)

QUERY: SELECT '' AS one, ABSTIME_TBL.*
   WHERE 'current'::abstime = ABSTIME_TBL.f1;
one|f1     
---+-------
   |current
(1 row)

QUERY: SELECT '' AS three, ABSTIME_TBL.*
   WHERE 'epoch'::abstime >= ABSTIME_TBL.f1;
three|f1                          
-----+----------------------------
     |epoch                       
     |-infinity                   
     |Sat May 10 23:59:12 1947 PST
(3 rows)

QUERY: SELECT '' AS four, ABSTIME_TBL.*
   WHERE ABSTIME_TBL.f1 <= 'Jan 14, 1973 03:14:21'::abstime;
four|f1                          
----+----------------------------
    |Sun Jan 14 03:14:21 1973 PST
    |epoch                       
    |-infinity                   
    |Sat May 10 23:59:12 1947 PST
(4 rows)

QUERY: SELECT '' AS four, ABSTIME_TBL.*
  WHERE ABSTIME_TBL.f1 <?>
	'["Apr 1 1950 00:00:00" "Dec 30 1999 23:00:00"]'::tinterval;
four|f1                          
----+----------------------------
    |Sun Jan 14 03:14:21 1973 PST
    |Mon May 01 00:30:30 1995 PDT
    |epoch                       
    |current                     
(4 rows)

QUERY: SELECT '' AS three, ABSTIME_TBL.*
  WHERE  (ABSTIME_TBL.f1 + '@ 3 year'::reltime) 
	< 'Jan 14 14:00:00 1977'::abstime;
three|f1                          
-----+----------------------------
     |Sun Jan 14 03:14:21 1973 PST
     |epoch                       
     |Sat May 10 23:59:12 1947 PST
(3 rows)

QUERY: SELECT '' AS three, ABSTIME_TBL.*
   WHERE  (ABSTIME_TBL.f1 + '@ 3 year ago'::reltime)	
	< 'Jan 14 14:00:00 1971'::abstime;
three|f1                          
-----+----------------------------
     |Sun Jan 14 03:14:21 1973 PST
     |epoch                       
     |Sat May 10 23:59:12 1947 PST
(3 rows)

QUERY: SELECT '' AS three, ABSTIME_TBL.*
   WHERE  (ABSTIME_TBL.f1 - '@ 3 year'::reltime)        
	< 'Jan 14 14:00:00 1971'::abstime;
three|f1                          
-----+----------------------------
     |Sun Jan 14 03:14:21 1973 PST
     |epoch                       
     |Sat May 10 23:59:12 1947 PST
(3 rows)

QUERY: SELECT '' AS three, ABSTIME_TBL.*
   WHERE  (ABSTIME_TBL.f1 - '@ 3 year ago'::reltime)    
        < 'Jan 14 14:00:00 1977'::abstime;
three|f1                          
-----+----------------------------
     |Sun Jan 14 03:14:21 1973 PST
     |epoch                       
     |Sat May 10 23:59:12 1947 PST
(3 rows)

QUERY: SELECT '' AS ten, ABSTIME_TBL.f1 AS abstime, RELTIME_TBL.f1 AS reltime
   WHERE (ABSTIME_TBL.f1 + RELTIME_TBL.f1)
	< 'Jan 14 14:00:00 1971'::abstime
   ORDER BY abstime, reltime;
ten|abstime                     |reltime      
---+----------------------------+-------------
   |Sat May 10 23:59:12 1947 PST|@ 14 secs ago
   |Sat May 10 23:59:12 1947 PST|@ 1 min      
   |Sat May 10 23:59:12 1947 PST|@ 5 hours    
   |Sat May 10 23:59:12 1947 PST|@ 10 days    
   |Sat May 10 23:59:12 1947 PST|@ 3 mons     
   |epoch                       |@ 14 secs ago
   |epoch                       |@ 1 min      
   |epoch                       |@ 5 hours    
   |epoch                       |@ 10 days    
   |epoch                       |@ 3 mons     
(10 rows)