MobilityDB  1.0
timeops.h
Go to the documentation of this file.
1 /*****************************************************************************
2  *
3  * This MobilityDB code is provided under The PostgreSQL License.
4  *
5  * Copyright (c) 2016-2021, Université libre de Bruxelles and MobilityDB
6  * contributors
7  *
8  * MobilityDB includes portions of PostGIS version 3 source code released
9  * under the GNU General Public License (GPLv2 or later).
10  * Copyright (c) 2001-2021, PostGIS contributors
11  *
12  * Permission to use, copy, modify, and distribute this software and its
13  * documentation for any purpose, without fee, and without a written
14  * agreement is hereby granted, provided that the above copyright notice and
15  * this paragraph and the following two paragraphs appear in all copies.
16  *
17  * IN NO EVENT SHALL UNIVERSITE LIBRE DE BRUXELLES BE LIABLE TO ANY PARTY FOR
18  * DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING
19  * LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION,
20  * EVEN IF UNIVERSITE LIBRE DE BRUXELLES HAS BEEN ADVISED OF THE POSSIBILITY
21  * OF SUCH DAMAGE.
22  *
23  * UNIVERSITE LIBRE DE BRUXELLES SPECIFICALLY DISCLAIMS ANY WARRANTIES,
24  * INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
25  * AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON
26  * AN "AS IS" BASIS, AND UNIVERSITE LIBRE DE BRUXELLES HAS NO OBLIGATIONS TO
27  * PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. 
28  *
29  *****************************************************************************/
30 
36 #ifndef __TIMEOPS_H__
37 #define __TIMEOPS_H__
38 
39 #include <postgres.h>
40 #include <catalog/pg_type.h>
41 #include "timetypes.h"
42 
43 /*****************************************************************************/
44 
48 typedef enum
49 {
50  BEFORE,
51  DURING,
52  AFTER
53 } RelativeTimePos;
54 
55 /* Miscellaneous */
56 
57 extern void ensure_time_type_oid(Oid timetypid);
58 
59 /* Functions for aggregations */
60 
61 extern RelativeTimePos pos_timestamp_timestamp(TimestampTz t1, TimestampTz t2);
62 extern RelativeTimePos pos_period_timestamp(const Period *p, TimestampTz t);
63 
64 /* contains? */
65 
66 extern Datum contains_timestampset_timestamp(PG_FUNCTION_ARGS);
67 extern Datum contains_timestampset_timestampset(PG_FUNCTION_ARGS);
68 extern Datum contains_period_timestamp(PG_FUNCTION_ARGS);
69 extern Datum contains_period_timestampset(PG_FUNCTION_ARGS);
70 extern Datum contains_period_period(PG_FUNCTION_ARGS);
71 extern Datum contains_periodset_timestamp(PG_FUNCTION_ARGS);
72 extern Datum contains_periodset_timestampset(PG_FUNCTION_ARGS);
73 extern Datum contains_periodset_period(PG_FUNCTION_ARGS);
74 extern Datum contains_period_periodset(PG_FUNCTION_ARGS);
75 extern Datum contains_periodset_periodset(PG_FUNCTION_ARGS);
76 
77 extern bool contains_timestampset_timestamp_internal(const TimestampSet *ts, TimestampTz t);
78 extern bool contains_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2);
79 extern bool contains_period_timestamp_internal(const Period *p, TimestampTz t);
80 extern bool contains_period_timestampset_internal(const Period *p, const TimestampSet *ts);
81 extern bool contains_period_period_internal(const Period *p1, const Period *p2);
82 extern bool contains_periodset_timestamp_internal(const PeriodSet *ps, TimestampTz t);
83 extern bool contains_periodset_timestampset_internal(const PeriodSet *ps, const TimestampSet *ts);
84 extern bool contains_periodset_period_internal(const PeriodSet *ps, const Period *p);
85 extern bool contains_period_periodset_internal(const Period *p, const PeriodSet *ps);
86 extern bool contains_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2);
87 
88 /* contained? */
89 
90 extern Datum contained_timestamp_timestampset(PG_FUNCTION_ARGS);
91 extern Datum contained_timestamp_period(PG_FUNCTION_ARGS);
92 extern Datum contained_timestamp_periodset(PG_FUNCTION_ARGS);
93 extern Datum contained_timestampset_timestampset(PG_FUNCTION_ARGS);
94 extern Datum contained_timestampset_period(PG_FUNCTION_ARGS);
95 extern Datum contained_timestampset_periodset(PG_FUNCTION_ARGS);
96 extern Datum contained_period_period(PG_FUNCTION_ARGS);
97 extern Datum contained_period_periodset(PG_FUNCTION_ARGS);
98 extern Datum contained_periodset_period(PG_FUNCTION_ARGS);
99 extern Datum contained_periodset_periodset(PG_FUNCTION_ARGS);
100 
101 extern bool contained_period_period_internal(const Period *p1, const Period *p2);
102 
103 /* overlaps? */
104 
105 extern Datum overlaps_timestampset_timestampset(PG_FUNCTION_ARGS);
106 extern Datum overlaps_period_timestampset(PG_FUNCTION_ARGS);
107 extern Datum overlaps_period_period(PG_FUNCTION_ARGS);
108 extern Datum overlaps_periodset_timestampset(PG_FUNCTION_ARGS);
109 extern Datum overlaps_periodset_period(PG_FUNCTION_ARGS);
110 extern Datum overlaps_period_periodset(PG_FUNCTION_ARGS);
111 extern Datum overlaps_periodset_periodset(PG_FUNCTION_ARGS);
112 
113 extern bool overlaps_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2);
114 extern bool overlaps_timestampset_period_internal(const TimestampSet *ts, const Period *p);
115 extern bool overlaps_timestampset_periodset_internal(const TimestampSet *ts, const PeriodSet *ps);
116 extern bool overlaps_period_period_internal(const Period *p1, const Period *p2);
117 extern bool overlaps_period_periodset_internal(const Period *p, const PeriodSet *ps);
118 extern bool overlaps_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2);
119 
120 /* before */
121 
122 extern Datum before_timestamp_timestampset(PG_FUNCTION_ARGS);
123 extern Datum before_timestamp_period(PG_FUNCTION_ARGS);
124 extern Datum before_timestamp_periodset(PG_FUNCTION_ARGS);
125 extern Datum before_timestampset_timestamp(PG_FUNCTION_ARGS);
126 extern Datum before_timestampset_timestampset(PG_FUNCTION_ARGS);
127 extern Datum before_timestampset_period(PG_FUNCTION_ARGS);
128 extern Datum before_timestampset_periodset(PG_FUNCTION_ARGS);
129 extern Datum before_period_timestamp(PG_FUNCTION_ARGS);
130 extern Datum before_period_period(PG_FUNCTION_ARGS);
131 extern Datum before_periodset_timestampset(PG_FUNCTION_ARGS);
132 extern Datum before_period_timestampset(PG_FUNCTION_ARGS);
133 extern Datum before_periodset_timestamp(PG_FUNCTION_ARGS);
134 extern Datum before_periodset_period(PG_FUNCTION_ARGS);
135 extern Datum before_period_periodset(PG_FUNCTION_ARGS);
136 extern Datum before_periodset_periodset(PG_FUNCTION_ARGS);
137 
138 extern bool before_timestamp_timestampset_internal(TimestampTz t, const TimestampSet *ts);
139 extern bool before_timestamp_period_internal(TimestampTz t, const Period *p);
140 extern bool before_timestamp_periodset_internal(TimestampTz t, const PeriodSet *ps);
141 extern bool before_timestampset_timestamp_internal(const TimestampSet *ts, TimestampTz t);
142 extern bool before_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2);
143 extern bool before_timestampset_period_internal(const TimestampSet *ts, const Period *p);
144 extern bool before_timestampset_periodset_internal(const TimestampSet *ts, const PeriodSet *ps);
145 extern bool before_period_timestamp_internal(const Period *p, TimestampTz t);
146 extern bool before_period_period_internal(const Period *p1, const Period *p2);
147 extern bool before_periodset_timestampset_internal(const PeriodSet *ps, const TimestampSet *ts);
148 extern bool before_period_timestampset_internal(const Period *p, const TimestampSet *ts);
149 extern bool before_periodset_timestamp_internal(const PeriodSet *ps, TimestampTz t);
150 extern bool before_periodset_period_internal(const PeriodSet *ps, const Period *p);
151 extern bool before_period_periodset_internal(const Period *p, const PeriodSet *ps);
152 extern bool before_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2);
153 
154 /* after */
155 
156 extern Datum after_timestamp_timestampset(PG_FUNCTION_ARGS);
157 extern Datum after_timestamp_period(PG_FUNCTION_ARGS);
158 extern Datum after_timestamp_periodset(PG_FUNCTION_ARGS);
159 extern Datum after_timestampset_timestamp(PG_FUNCTION_ARGS);
160 extern Datum after_timestampset_timestampset(PG_FUNCTION_ARGS);
161 extern Datum after_timestampset_period(PG_FUNCTION_ARGS);
162 extern Datum after_timestampset_periodset(PG_FUNCTION_ARGS);
163 extern Datum after_period_timestamp(PG_FUNCTION_ARGS);
164 extern Datum after_period_period(PG_FUNCTION_ARGS);
165 extern Datum after_periodset_timestampset(PG_FUNCTION_ARGS);
166 extern Datum after_period_timestampset(PG_FUNCTION_ARGS);
167 extern Datum after_periodset_timestamp(PG_FUNCTION_ARGS);
168 extern Datum after_periodset_period(PG_FUNCTION_ARGS);
169 extern Datum after_period_periodset(PG_FUNCTION_ARGS);
170 extern Datum after_periodset_periodset(PG_FUNCTION_ARGS);
171 
172 extern bool after_timestamp_timestampset_internal(TimestampTz t, const TimestampSet *ts);
173 extern bool after_timestamp_period_internal(TimestampTz t, const Period *p);
174 extern bool after_timestamp_periodset_internal(TimestampTz t, const PeriodSet *ps);
175 extern bool after_timestampset_timestamp_internal(const TimestampSet *ts, TimestampTz t);
176 extern bool after_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2);
177 extern bool after_timestampset_period_internal(const TimestampSet *ts, const Period *p);
178 extern bool after_timestampset_periodset_internal(const TimestampSet *ts, const PeriodSet *ps);
179 extern bool after_period_timestamp_internal(const Period *p, TimestampTz t);
180 extern bool after_period_period_internal(const Period *p1, const Period *p2);
181 extern bool after_periodset_timestampset_internal(const PeriodSet *ps, const TimestampSet *ts);
182 extern bool after_period_timestampset_internal(const Period *p, const TimestampSet *ts);
183 extern bool after_periodset_timestamp_internal(const PeriodSet *ps, TimestampTz t);
184 extern bool after_periodset_period_internal(const PeriodSet *ps, const Period *p);
185 extern bool after_period_periodset_internal(const Period *p, const PeriodSet *ps);
186 extern bool after_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2);
187 
188 /* overbefore */
189 
190 extern Datum overbefore_timestamp_timestampset(PG_FUNCTION_ARGS);
191 extern Datum overbefore_timestamp_period(PG_FUNCTION_ARGS);
192 extern Datum overbefore_timestamp_periodset(PG_FUNCTION_ARGS);
193 extern Datum overbefore_timestampset_timestamp(PG_FUNCTION_ARGS);
194 extern Datum overbefore_timestampset_timestampset(PG_FUNCTION_ARGS);
195 extern Datum overbefore_timestampset_period(PG_FUNCTION_ARGS);
196 extern Datum overbefore_timestampset_periodset(PG_FUNCTION_ARGS);
197 extern Datum overbefore_period_timestamp(PG_FUNCTION_ARGS);
198 extern Datum overbefore_period_period(PG_FUNCTION_ARGS);
199 extern Datum overbefore_periodset_timestampset(PG_FUNCTION_ARGS);
200 extern Datum overbefore_period_timestampset(PG_FUNCTION_ARGS);
201 extern Datum overbefore_periodset_timestamp(PG_FUNCTION_ARGS);
202 extern Datum overbefore_periodset_period(PG_FUNCTION_ARGS);
203 extern Datum overbefore_period_periodset(PG_FUNCTION_ARGS);
204 extern Datum overbefore_periodset_periodset(PG_FUNCTION_ARGS);
205 
206 extern bool overbefore_timestamp_timestampset_internal(TimestampTz t, const TimestampSet *ts);
207 extern bool overbefore_timestamp_period_internal(TimestampTz t, const Period *p);
208 extern bool overbefore_timestamp_periodset_internal(TimestampTz t, const PeriodSet *ps);
209 extern bool overbefore_timestampset_timestamp_internal(const TimestampSet *ts, TimestampTz t);
210 extern bool overbefore_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2);
211 extern bool overbefore_timestampset_period_internal(const TimestampSet *ts, const Period *p);
212 extern bool overbefore_timestampset_periodset_internal(const TimestampSet *ts, const PeriodSet *ps);
213 extern bool overbefore_period_timestamp_internal(const Period *p, TimestampTz t);
214 extern bool overbefore_period_period_internal(const Period *p1, const Period *p2);
215 extern bool overbefore_periodset_timestampset_internal(const PeriodSet *ps, const TimestampSet *ts);
216 extern bool overbefore_period_timestampset_internal(const Period *p, const TimestampSet *ts);
217 extern bool overbefore_periodset_timestamp_internal(const PeriodSet *ps, TimestampTz t);
218 extern bool overbefore_periodset_period_internal(const PeriodSet *ps, const Period *p);
219 extern bool overbefore_period_periodset_internal(const Period *p, const PeriodSet *ps);
220 extern bool overbefore_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2);
221 
222 /* overafter */
223 
224 extern Datum overafter_timestamp_timestampset(PG_FUNCTION_ARGS);
225 extern Datum overafter_timestamp_period(PG_FUNCTION_ARGS);
226 extern Datum overafter_timestamp_periodset(PG_FUNCTION_ARGS);
227 extern Datum overafter_timestampset_timestamp(PG_FUNCTION_ARGS);
228 extern Datum overafter_timestampset_timestampset(PG_FUNCTION_ARGS);
229 extern Datum overafter_timestampset_period(PG_FUNCTION_ARGS);
230 extern Datum overafter_timestampset_periodset(PG_FUNCTION_ARGS);
231 extern Datum overafter_period_timestamp(PG_FUNCTION_ARGS);
232 extern Datum overafter_period_period(PG_FUNCTION_ARGS);
233 extern Datum overafter_periodset_timestampset(PG_FUNCTION_ARGS);
234 extern Datum overafter_period_timestampset(PG_FUNCTION_ARGS);
235 extern Datum overafter_periodset_timestamp(PG_FUNCTION_ARGS);
236 extern Datum overafter_periodset_period(PG_FUNCTION_ARGS);
237 extern Datum overafter_period_periodset(PG_FUNCTION_ARGS);
238 extern Datum overafter_periodset_periodset(PG_FUNCTION_ARGS);
239 
240 extern bool overafter_timestamp_timestampset_internal(TimestampTz t, const TimestampSet *ts);
241 extern bool overafter_timestamp_period_internal(TimestampTz t, const Period *p);
242 extern bool overafter_timestamp_periodset_internal(TimestampTz t, const PeriodSet *ps);
243 extern bool overafter_timestampset_timestamp_internal(const TimestampSet *ts, TimestampTz t);
244 extern bool overafter_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2);
245 extern bool overafter_timestampset_period_internal(const TimestampSet *ts, const Period *p);
246 extern bool overafter_timestampset_periodset_internal(const TimestampSet *ts, const PeriodSet *ps);
247 extern bool overafter_period_timestamp_internal(const Period *p, TimestampTz t);
248 extern bool overafter_period_period_internal(const Period *p1, const Period *p2);
249 extern bool overafter_periodset_timestampset_internal(const PeriodSet *ps, const TimestampSet *ts);
250 extern bool overafter_period_timestampset_internal(const Period *p, const TimestampSet *ts);
251 extern bool overafter_periodset_timestamp_internal(const PeriodSet *ps, TimestampTz t);
252 extern bool overafter_periodset_period_internal(const PeriodSet *ps, const Period *p);
253 extern bool overafter_period_periodset_internal(const Period *p, const PeriodSet *ps);
254 extern bool overafter_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2);
255 
256 /* adjacent */
257 
258 extern Datum adjacent_timestamp_period(PG_FUNCTION_ARGS);
259 extern Datum adjacent_timestamp_periodset(PG_FUNCTION_ARGS);
260 extern Datum adjacent_timestampset_period(PG_FUNCTION_ARGS);
261 extern Datum adjacent_timestampset_periodset(PG_FUNCTION_ARGS);
262 extern Datum adjacent_period_timestamp(PG_FUNCTION_ARGS);
263 extern Datum adjacent_period_timestampset(PG_FUNCTION_ARGS);
264 extern Datum adjacent_period_period(PG_FUNCTION_ARGS);
265 extern Datum adjacent_period_periodset(PG_FUNCTION_ARGS);
266 extern Datum adjacent_periodset_timestamp(PG_FUNCTION_ARGS);
267 extern Datum adjacent_periodset_timestampset(PG_FUNCTION_ARGS);
268 extern Datum adjacent_periodset_period(PG_FUNCTION_ARGS);
269 extern Datum adjacent_periodset_periodset(PG_FUNCTION_ARGS);
270 
271 extern bool adjacent_timestamp_period_internal(TimestampTz t, const Period *p);
272 extern bool adjacent_timestamp_periodset_internal(TimestampTz t, const PeriodSet *ps);
273 extern bool adjacent_timestampset_period_internal(const TimestampSet *ts, const Period *p);
274 extern bool adjacent_timestampset_periodset_internal(const TimestampSet *ts, const PeriodSet *ps);
275 extern bool adjacent_period_timestamp_internal(const Period *p, TimestampTz t);
276 extern bool adjacent_period_timestampset_internal(const Period *p, const TimestampSet *ts);
277 extern bool adjacent_period_period_internal(const Period *p1, const Period *p2);
278 extern bool adjacent_period_periodset_internal(const Period *p, const PeriodSet *ps);
279 extern bool adjacent_periodset_timestamp_internal(const PeriodSet *ps, TimestampTz t);
280 extern bool adjacent_periodset_timestampset_internal(const PeriodSet *ps, const TimestampSet *ts);
281 extern bool adjacent_periodset_period_internal(const PeriodSet *ps, const Period *p);
282 extern bool adjacent_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2);
283 
284 /* union */
285 
286 extern Datum union_timestamp_timestamp(PG_FUNCTION_ARGS);
287 extern Datum union_timestamp_timestampset(PG_FUNCTION_ARGS);
288 extern Datum union_timestamp_period(PG_FUNCTION_ARGS);
289 extern Datum union_timestamp_periodset(PG_FUNCTION_ARGS);
290 extern Datum union_timestampset_timestamp(PG_FUNCTION_ARGS);
291 extern Datum union_timestampset_timestampset(PG_FUNCTION_ARGS);
292 extern Datum union_timestampset_period(PG_FUNCTION_ARGS);
293 extern Datum union_timestampset_periodset(PG_FUNCTION_ARGS);
294 extern Datum union_period_timestamp(PG_FUNCTION_ARGS);
295 extern Datum union_period_timestampset(PG_FUNCTION_ARGS);
296 extern Datum union_period_period(PG_FUNCTION_ARGS);
297 extern Datum union_period_periodset(PG_FUNCTION_ARGS);
298 extern Datum union_periodset_timestamp(PG_FUNCTION_ARGS);
299 extern Datum union_periodset_timestampset(PG_FUNCTION_ARGS);
300 extern Datum union_periodset_period(PG_FUNCTION_ARGS);
301 extern Datum union_periodset_periodset(PG_FUNCTION_ARGS);
302 
303 extern TimestampSet *union_timestamp_timestampset_internal(TimestampTz t, const TimestampSet *ts);
304 extern TimestampSet *union_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2);
305 extern PeriodSet *union_period_period_internal(const Period *p1, const Period *p2);
306 extern PeriodSet *union_period_periodset_internal(const Period *p, const PeriodSet *ps);
307 extern PeriodSet *union_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2);
308 
309 /* intersection */
310 
311 extern Datum intersection_timestamp_timestamp(PG_FUNCTION_ARGS);
312 extern Datum intersection_timestamp_timestampset(PG_FUNCTION_ARGS);
313 extern Datum intersection_timestamp_period(PG_FUNCTION_ARGS);
314 extern Datum intersection_timestamp_periodset(PG_FUNCTION_ARGS);
315 extern Datum intersection_timestampset_timestamp(PG_FUNCTION_ARGS);
316 extern Datum intersection_timestampset_timestampset(PG_FUNCTION_ARGS);
317 extern Datum intersection_timestampset_period(PG_FUNCTION_ARGS);
318 extern Datum intersection_timestampset_periodset(PG_FUNCTION_ARGS);
319 extern Datum intersection_period_timestamp(PG_FUNCTION_ARGS);
320 extern Datum intersection_period_timestampset(PG_FUNCTION_ARGS);
321 extern Datum intersection_period_period(PG_FUNCTION_ARGS);
322 extern Datum intersection_period_periodset(PG_FUNCTION_ARGS);
323 extern Datum intersection_periodset_timestamp(PG_FUNCTION_ARGS);
324 extern Datum intersection_periodset_timestampset(PG_FUNCTION_ARGS);
325 extern Datum intersection_periodset_period(PG_FUNCTION_ARGS);
326 extern Datum intersection_periodset_periodset(PG_FUNCTION_ARGS);
327 
328 extern TimestampSet *intersection_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2);
329 extern TimestampSet *intersection_timestampset_period_internal(const TimestampSet *ts, const Period *p);
330 extern Period *intersection_period_period_internal(const Period *p1, const Period *p2);
331 extern PeriodSet *intersection_period_periodset_internal(const Period *p, const PeriodSet *ps);
332 extern PeriodSet *intersection_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2);
333 
334 /* minus */
335 
336 extern Datum minus_timestamp_timestamp(PG_FUNCTION_ARGS);
337 extern Datum minus_timestamp_timestampset(PG_FUNCTION_ARGS);
338 extern Datum minus_timestamp_period(PG_FUNCTION_ARGS);
339 extern Datum minus_timestamp_periodset(PG_FUNCTION_ARGS);
340 extern Datum minus_timestampset_timestamp(PG_FUNCTION_ARGS);
341 extern Datum minus_timestampset_timestampset(PG_FUNCTION_ARGS);
342 extern Datum minus_timestampset_period(PG_FUNCTION_ARGS);
343 extern Datum minus_timestampset_periodset(PG_FUNCTION_ARGS);
344 extern Datum minus_period_timestamp(PG_FUNCTION_ARGS);
345 extern Datum minus_period_timestampset(PG_FUNCTION_ARGS);
346 extern Datum minus_period_period(PG_FUNCTION_ARGS);
347 extern Datum minus_period_periodset(PG_FUNCTION_ARGS);
348 extern Datum minus_periodset_timestamp(PG_FUNCTION_ARGS);
349 extern Datum minus_periodset_timestampset(PG_FUNCTION_ARGS);
350 extern Datum minus_periodset_period(PG_FUNCTION_ARGS);
351 extern Datum minus_periodset_periodset(PG_FUNCTION_ARGS);
352 
353 extern TimestampSet *minus_timestampset_timestamp_internal(const TimestampSet *ts, TimestampTz t);
354 extern TimestampSet *minus_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2);
355 extern TimestampSet *minus_timestampset_period_internal(const TimestampSet *ts, const Period *p);
356 extern TimestampSet *minus_timestampset_periodset_internal(const TimestampSet *ts, const PeriodSet *ps);
357 extern PeriodSet *minus_period_timestamp_internal(const Period *p, TimestampTz t);
358 extern PeriodSet *minus_period_timestampset_internal(const Period *p, const TimestampSet *ts);
359 extern PeriodSet *minus_period_period_internal(const Period *p1, const Period *p2);
360 extern PeriodSet *minus_period_periodset_internal(const Period *p, const PeriodSet *ps);
361 extern PeriodSet *minus_periodset_timestamp_internal(const PeriodSet *ps, TimestampTz t);
362 extern PeriodSet *minus_periodset_timestampset_internal(const PeriodSet *ps, const TimestampSet *ts);
363 extern PeriodSet *minus_periodset_period_internal(const PeriodSet *ps, const Period *p);
364 extern PeriodSet *minus_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2);
365 
366 #endif
367 
368 /*****************************************************************************/
overafter_timestampset_periodset_internal
bool overafter_timestampset_periodset_internal(const TimestampSet *ts, const PeriodSet *ps)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2340
adjacent_timestamp_period
Datum adjacent_timestamp_period(PG_FUNCTION_ARGS)
Returns true if the two time value are adjacent.
Definition: timeops.c:2583
before_timestampset_timestamp
Datum before_timestampset_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1134
overafter_period_timestamp_internal
bool overafter_period_timestamp_internal(const Period *p, TimestampTz t)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2367
minus_timestampset_periodset_internal
TimestampSet * minus_timestampset_periodset_internal(const TimestampSet *ts, const PeriodSet *ps)
Returns the difference of the two time values (internal function)
Definition: timeops.c:3846
union_periodset_timestampset
Datum union_periodset_timestampset(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:3153
overlaps_timestampset_period_internal
bool overlaps_timestampset_period_internal(const TimestampSet *ts, const Period *p)
Returns true if the two time values overlap (internal function)
Definition: timeops.c:812
Period
Structure to represent periods.
Definition: timetypes.h:52
before_period_timestampset_internal
bool before_period_timestampset_internal(const Period *p, const TimestampSet *ts)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1251
intersection_timestampset_timestampset_internal
TimestampSet * intersection_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2)
Returns the intersection of the two time values (internal function)
Definition: timeops.c:3380
union_timestamp_periodset
Datum union_timestamp_periodset(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:2940
overbefore_periodset_periodset
Datum overbefore_periodset_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:2172
after_timestampset_timestamp_internal
bool after_timestampset_timestamp_internal(const TimestampSet *ts, TimestampTz t)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1504
minus_timestampset_timestampset_internal
TimestampSet * minus_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2)
Returns the difference of the two time values (internal function)
Definition: timeops.c:3793
RelativeTimePos
RelativeTimePos
Enumeration for the relative position of a given element into a skiplist.
Definition: timeops.h:48
intersection_period_timestamp
Datum intersection_period_timestamp(PG_FUNCTION_ARGS)
Returns the intersection of the two time values.
Definition: timeops.c:3462
minus_periodset_timestamp_internal
PeriodSet * minus_periodset_timestamp_internal(const PeriodSet *ps, TimestampTz t)
Returns the difference of the two time values (internal function)
Definition: timeops.c:4149
minus_periodset_timestampset_internal
PeriodSet * minus_periodset_timestampset_internal(const PeriodSet *ps, const TimestampSet *ts)
Returns the difference of the two time values (internal function)
Definition: timeops.c:4188
after_periodset_timestampset_internal
bool after_periodset_timestampset_internal(const PeriodSet *ps, const TimestampSet *ts)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1729
after_period_timestamp_internal
bool after_period_timestamp_internal(const Period *p, TimestampTz t)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1608
contained_period_period
Datum contained_period_period(PG_FUNCTION_ARGS)
Returns true if the first time value is contained by the second one.
Definition: timeops.c:712
overlaps_period_periodset
Datum overlaps_period_periodset(PG_FUNCTION_ARGS)
Returns true if the two time values overlap.
Definition: timeops.c:956
minus_timestamp_period
Datum minus_timestamp_period(PG_FUNCTION_ARGS)
Returns the difference of the two time values.
Definition: timeops.c:3722
intersection_periodset_periodset_internal
PeriodSet * intersection_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2)
Returns the intersection of the two time values (internal function)
Definition: timeops.c:3628
before_periodset_periodset_internal
bool before_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1401
overafter_timestampset_timestamp_internal
bool overafter_timestampset_timestamp_internal(const TimestampSet *ts, TimestampTz t)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2263
overbefore_timestampset_timestampset_internal
bool overbefore_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:1909
adjacent_timestampset_periodset
Datum adjacent_timestampset_periodset(PG_FUNCTION_ARGS)
Returns true if the two time value are adjacent.
Definition: timeops.c:2673
overlaps_periodset_periodset_internal
bool overlaps_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2)
Returns true if the two time values overlap (internal function)
Definition: timeops.c:998
overafter_period_periodset_internal
bool overafter_period_periodset_internal(const Period *p, const PeriodSet *ps)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2437
before_periodset_timestampset
Datum before_periodset_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1361
ensure_time_type_oid
void ensure_time_type_oid(Oid timetypid)
Ensure that the Oid corresponds to a time type.
Definition: timeops.c:60
before_period_period
Datum before_period_period(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1287
after_period_periodset
Datum after_period_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1690
union_period_periodset_internal
PeriodSet * union_period_periodset_internal(const Period *p, const PeriodSet *ps)
Returns the union of the two time values (internal function)
Definition: timeops.c:3106
adjacent_timestamp_period_internal
bool adjacent_timestamp_period_internal(TimestampTz t, const Period *p)
Returns true if the two time value are adjacent (internal function)
Definition: timeops.c:2568
overbefore_periodset_timestampset_internal
bool overbefore_periodset_timestampset_internal(const PeriodSet *ps, const TimestampSet *ts)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:2108
intersection_timestampset_period_internal
TimestampSet * intersection_timestampset_period_internal(const TimestampSet *ts, const Period *p)
Returns the intersection of the two time values (internal function)
Definition: timeops.c:3407
minus_timestampset_timestamp_internal
TimestampSet * minus_timestampset_timestamp_internal(const TimestampSet *ts, TimestampTz t)
Returns the difference of the two time values (internal function)
Definition: timeops.c:3755
minus_timestamp_timestamp
Datum minus_timestamp_timestamp(PG_FUNCTION_ARGS)
Returns the difference of the two time values (internal function)
Definition: timeops.c:3692
overafter_periodset_timestampset_internal
bool overafter_periodset_timestampset_internal(const PeriodSet *ps, const TimestampSet *ts)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2487
minus_period_timestampset
Datum minus_period_timestampset(PG_FUNCTION_ARGS)
Returns the difference of the two time valuess.
Definition: timeops.c:3961
contained_timestampset_period
Datum contained_timestampset_period(PG_FUNCTION_ARGS)
Returns true if the first time value is contained by the second one.
Definition: timeops.c:673
after_timestampset_timestamp
Datum after_timestampset_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1515
union_periodset_periodset
Datum union_periodset_periodset(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:3284
before_timestamp_timestampset_internal
bool before_timestamp_timestampset_internal(TimestampTz t, const TimestampSet *ts)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1050
intersection_periodset_period
Datum intersection_periodset_period(PG_FUNCTION_ARGS)
Returns the intersection of the two time values.
Definition: timeops.c:3613
adjacent_periodset_timestamp_internal
bool adjacent_periodset_timestamp_internal(const PeriodSet *ps, TimestampTz t)
overbefore_period_periodset_internal
bool overbefore_period_periodset_internal(const Period *p, const PeriodSet *ps)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:2058
after_timestampset_period_internal
bool after_timestampset_period_internal(const TimestampSet *ts, const Period *p)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1556
overlaps_timestampset_timestampset_internal
bool overlaps_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2)
Returns true if the two time values overlap (internal function)
Definition: timeops.c:769
contains_periodset_period
Datum contains_periodset_period(PG_FUNCTION_ARGS)
Returns true if the first time value contains the second one.
Definition: timeops.c:519
contains_periodset_timestampset
Datum contains_periodset_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value contains the second one.
Definition: timeops.c:487
contains_period_period_internal
bool contains_period_period_internal(const Period *p1, const Period *p2)
Returns true if the first time value contains the second one (internal function)
Definition: timeops.c:397
overafter_period_timestampset
Datum overafter_period_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2400
union_timestampset_timestampset_internal
TimestampSet * union_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2)
Returns the union of the two time values (internal function)
Definition: timeops.c:2971
overafter_period_periodset
Datum overafter_period_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2448
overbefore_period_period
Datum overbefore_period_period(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:2046
overbefore_timestamp_timestampset_internal
bool overbefore_timestamp_timestampset_internal(TimestampTz t, const TimestampSet *ts)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:1811
contains_period_timestamp_internal
bool contains_period_timestamp_internal(const Period *p, TimestampTz t)
Returns true if the first time value contains the second one (internal function)
Definition: timeops.c:341
after_period_timestampset
Datum after_period_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1642
intersection_periodset_timestampset
Datum intersection_periodset_timestampset(PG_FUNCTION_ARGS)
Returns the intersection of the two time values.
Definition: timeops.c:3596
overbefore_timestamp_period
Datum overbefore_timestamp_period(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:1847
adjacent_timestampset_periodset_internal
bool adjacent_timestampset_periodset_internal(const TimestampSet *ts, const PeriodSet *ps)
Returns true if the two time value are adjacent (internal function)
Definition: timeops.c:2654
overafter_periodset_periodset
Datum overafter_periodset_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2551
overbefore_period_timestampset
Datum overbefore_period_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:2021
overbefore_period_timestampset_internal
bool overbefore_period_timestampset_internal(const Period *p, const TimestampSet *ts)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:2010
before_timestamp_timestampset
Datum before_timestamp_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1061
overlaps_periodset_timestampset
Datum overlaps_periodset_timestampset(PG_FUNCTION_ARGS)
Returns true if the two time values overlap.
Definition: timeops.c:970
minus_periodset_timestampset
Datum minus_periodset_timestampset(PG_FUNCTION_ARGS)
Returns the difference of the two time values.
Definition: timeops.c:4300
minus_period_timestamp
Datum minus_period_timestamp(PG_FUNCTION_ARGS)
Returns the difference of the two time values.
Definition: timeops.c:3926
contains_periodset_timestamp
Datum contains_periodset_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value contains the second one.
Definition: timeops.c:443
overafter_periodset_period
Datum overafter_periodset_period(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2525
adjacent_period_timestampset_internal
bool adjacent_period_timestampset_internal(const Period *p, const TimestampSet *ts)
union_period_timestampset
Datum union_period_timestampset(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:3079
adjacent_timestamp_periodset
Datum adjacent_timestamp_periodset(PG_FUNCTION_ARGS)
Returns true if the two time value are adjacent.
Definition: timeops.c:2611
overafter_timestampset_period
Datum overafter_timestampset_period(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2326
overbefore_period_timestamp_internal
bool overbefore_period_timestamp_internal(const Period *p, TimestampTz t)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:1988
overbefore_periodset_periodset_internal
bool overbefore_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:2160
minus_periodset_periodset_internal
PeriodSet * minus_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2)
Returns the difference of the two time values (internal function)
Definition: timeops.c:4355
union_timestamp_timestampset
Datum union_timestamp_timestampset(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:2911
overafter_timestamp_periodset_internal
bool overafter_timestamp_periodset_internal(TimestampTz t, const PeriodSet *ps)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2238
adjacent_periodset_periodset
Datum adjacent_periodset_periodset(PG_FUNCTION_ARGS)
Returns true if the two time value are adjacent.
Definition: timeops.c:2831
union_period_timestamp
Datum union_period_timestamp(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:3064
intersection_period_periodset_internal
PeriodSet * intersection_period_periodset_internal(const Period *p, const PeriodSet *ps)
Returns the intersection of the two time values (internal function)
Definition: timeops.c:3528
contains_period_timestamp
Datum contains_period_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value contains the second one.
Definition: timeops.c:359
before_timestamp_periodset
Datum before_timestamp_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1109
before_timestampset_timestampset_internal
bool before_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1148
after_timestamp_timestampset
Datum after_timestamp_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1442
before_periodset_timestamp
Datum before_periodset_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1335
before_periodset_timestampset_internal
bool before_periodset_timestampset_internal(const PeriodSet *ps, const TimestampSet *ts)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1349
before_period_period_internal
bool before_period_period_internal(const Period *p1, const Period *p2)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1276
overbefore_period_timestamp
Datum overbefore_period_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:1998
contained_timestampset_periodset
Datum contained_timestampset_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is contained by the second one.
Definition: timeops.c:687
union_timestampset_periodset
Datum union_timestampset_periodset(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:3012
adjacent_periodset_timestampset_internal
bool adjacent_periodset_timestampset_internal(const PeriodSet *ps, const TimestampSet *ts)
adjacent_periodset_periodset_internal
bool adjacent_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2)
Returns true if the two time value are adjacent (internal function)
Definition: timeops.c:2812
minus_timestampset_period
Datum minus_timestampset_period(PG_FUNCTION_ARGS)
Returns the difference of the two time values.
Definition: timeops.c:3830
after_timestamp_timestampset_internal
bool after_timestamp_timestampset_internal(TimestampTz t, const TimestampSet *ts)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1431
contained_period_period_internal
bool contained_period_period_internal(const Period *p1, const Period *p2)
Returns true if the first time value is contained by the second one (internal function) ...
Definition: timeops.c:702
minus_timestampset_timestamp
Datum minus_timestampset_timestamp(PG_FUNCTION_ARGS)
Returns the difference of the two time values.
Definition: timeops.c:3778
after_timestamp_periodset_internal
bool after_timestamp_periodset_internal(TimestampTz t, const PeriodSet *ps)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1479
minus_periodset_timestamp
Datum minus_periodset_timestamp(PG_FUNCTION_ARGS)
Returns the difference of the two time values.
Definition: timeops.c:4173
minus_periodset_periodset
Datum minus_periodset_periodset(PG_FUNCTION_ARGS)
Returns the difference of the two time values (internal function)
Definition: timeops.c:4410
before_periodset_period_internal
bool before_periodset_period_internal(const PeriodSet *ps, const Period *p)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1376
before_period_periodset_internal
bool before_period_periodset_internal(const Period *p, const PeriodSet *ps)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1299
contains_period_periodset_internal
bool contains_period_periodset_internal(const Period *p, const PeriodSet *ps)
Returns true if the first time value contains the second one (internal function)
Definition: timeops.c:532
overafter_period_period
Datum overafter_period_period(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2425
contains_period_period
Datum contains_period_period(PG_FUNCTION_ARGS)
Returns true if the first time value contains the second one.
Definition: timeops.c:414
adjacent_period_period
Datum adjacent_period_period(PG_FUNCTION_ARGS)
Returns true if the two time value are adjacent.
Definition: timeops.c:2728
contained_timestamp_period
Datum contained_timestamp_period(PG_FUNCTION_ARGS)
Returns true if the first time value is contained by the second one.
Definition: timeops.c:632
after_timestampset_periodset
Datum after_timestampset_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1593
union_periodset_period
Datum union_periodset_period(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:3170
after_timestampset_timestampset_internal
bool after_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1529
overbefore_period_period_internal
bool overbefore_period_period_internal(const Period *p1, const Period *p2)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:2035
PeriodSet
Structure to represent period sets.
Definition: timetypes.h:84
before_period_periodset
Datum before_period_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1310
adjacent_period_periodset_internal
bool adjacent_period_periodset_internal(const Period *p, const PeriodSet *ps)
Returns true if the two time value are adjacent (internal function)
Definition: timeops.c:2739
after_timestampset_periodset_internal
bool after_timestampset_periodset_internal(const TimestampSet *ts, const PeriodSet *ps)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1581
minus_period_periodset_internal
PeriodSet * minus_period_periodset_internal(const Period *p, const PeriodSet *ps)
Definition: timeops.c:4114
contains_periodset_period_internal
bool contains_periodset_period_internal(const PeriodSet *ps, const Period *p)
Returns true if the first time value contains the second one (internal function)
Definition: timeops.c:501
before_timestampset_timestampset
Datum before_timestampset_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1160
intersection_timestamp_timestamp
Datum intersection_timestamp_timestamp(PG_FUNCTION_ARGS)
Returns the intersection of the two time values.
Definition: timeops.c:3303
minus_periodset_period
Datum minus_periodset_period(PG_FUNCTION_ARGS)
Returns the difference of the two time values.
Definition: timeops.c:4340
intersection_timestamp_period
Datum intersection_timestamp_period(PG_FUNCTION_ARGS)
Returns the intersection of the two time values.
Definition: timeops.c:3333
overlaps_period_period
Datum overlaps_period_period(PG_FUNCTION_ARGS)
Returns true if the two time values overlap.
Definition: timeops.c:919
contained_periodset_period
Datum contained_periodset_period(PG_FUNCTION_ARGS)
Returns true if the first time value is contained by the second one.
Definition: timeops.c:738
adjacent_periodset_period
Datum adjacent_periodset_period(PG_FUNCTION_ARGS)
Returns true if the two time value are adjacent.
Definition: timeops.c:2799
overafter_timestamp_period_internal
bool overafter_timestamp_period_internal(TimestampTz t, const Period *p)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2215
overbefore_timestampset_timestamp
Datum overbefore_timestampset_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:1895
overbefore_timestampset_timestamp_internal
bool overbefore_timestampset_timestamp_internal(const TimestampSet *ts, TimestampTz t)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:1884
overafter_timestampset_timestampset
Datum overafter_timestampset_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2300
union_timestamp_timestamp
Datum union_timestamp_timestamp(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:2850
before_timestampset_timestamp_internal
bool before_timestampset_timestamp_internal(const TimestampSet *ts, TimestampTz t)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1123
before_timestampset_period_internal
bool before_timestampset_period_internal(const TimestampSet *ts, const Period *p)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1175
overafter_period_timestamp
Datum overafter_period_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2377
intersection_timestamp_timestampset
Datum intersection_timestamp_timestampset(PG_FUNCTION_ARGS)
Returns the intersection of the two time values.
Definition: timeops.c:3317
timetypes.h
Functions for time types based on TimestampTz, that is, TimestampSet, Period, and PeriodSet...
contains_period_periodset
Datum contains_period_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value contains the second one.
Definition: timeops.c:543
overbefore_periodset_period
Datum overbefore_periodset_period(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:2146
before_periodset_periodset
Datum before_periodset_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1413
minus_period_timestamp_internal
PeriodSet * minus_period_timestamp_internal(const Period *p, TimestampTz t)
Returns the difference of the two time values (internal function)
Definition: timeops.c:3908
after_periodset_periodset
Datum after_periodset_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1793
overafter_timestampset_period_internal
bool overafter_timestampset_period_internal(const TimestampSet *ts, const Period *p)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2315
overafter_timestamp_periodset
Datum overafter_timestamp_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2249
overafter_timestamp_timestampset
Datum overafter_timestamp_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2201
after_period_timestampset_internal
bool after_period_timestampset_internal(const Period *p, const TimestampSet *ts)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1631
after_timestampset_timestampset
Datum after_timestampset_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1541
before_period_timestamp_internal
bool before_period_timestamp_internal(const Period *p, TimestampTz t)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1227
contained_timestamp_periodset
Datum contained_timestamp_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is contained by the second one.
Definition: timeops.c:644
union_period_periodset
Datum union_period_periodset(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:3121
intersection_period_timestampset
Datum intersection_period_timestampset(PG_FUNCTION_ARGS)
Returns the intersection of the two time values.
Definition: timeops.c:3478
overbefore_timestamp_timestampset
Datum overbefore_timestamp_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:1822
TimestampSet
Structure to represent timestamp sets.
Definition: timetypes.h:73
after_periodset_timestamp_internal
bool after_periodset_timestamp_internal(const PeriodSet *ps, TimestampTz t)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1704
intersection_periodset_timestamp
Datum intersection_periodset_timestamp(PG_FUNCTION_ARGS)
Returns the intersection of the two time values.
Definition: timeops.c:3580
adjacent_periodset_timestamp
Datum adjacent_periodset_timestamp(PG_FUNCTION_ARGS)
Returns true if the two time value are adjacent.
Definition: timeops.c:2770
union_period_period_internal
PeriodSet * union_period_period_internal(const Period *p1, const Period *p2)
Returns the union of the two time values (internal function)
Definition: timeops.c:3030
overbefore_timestamp_periodset_internal
bool overbefore_timestamp_periodset_internal(TimestampTz t, const PeriodSet *ps)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:1859
after_periodset_periodset_internal
bool after_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1781
after_periodset_timestamp
Datum after_periodset_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1715
intersection_timestampset_periodset
Datum intersection_timestampset_periodset(PG_FUNCTION_ARGS)
Returns the intersection of the two time values.
Definition: timeops.c:3443
adjacent_timestamp_periodset_internal
bool adjacent_timestamp_periodset_internal(TimestampTz t, const PeriodSet *ps)
Returns true if the two time value are adjacent (internal function)
Definition: timeops.c:2594
contained_periodset_periodset
Datum contained_periodset_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is contained by the second one.
Definition: timeops.c:752
after_periodset_period
Datum after_periodset_period(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1767
after_period_period_internal
bool after_period_period_internal(const Period *p1, const Period *p2)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1656
minus_timestampset_period_internal
TimestampSet * minus_timestampset_period_internal(const TimestampSet *ts, const Period *p)
Returns the difference of the two time values (internal function)
Definition: timeops.c:3820
minus_timestamp_timestampset
Datum minus_timestamp_timestampset(PG_FUNCTION_ARGS)
Returns the difference of the two time values.
Definition: timeops.c:3706
overafter_periodset_period_internal
bool overafter_periodset_period_internal(const PeriodSet *ps, const Period *p)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2514
overbefore_timestampset_period
Datum overbefore_timestampset_period(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:1947
overafter_timestampset_periodset
Datum overafter_timestampset_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2352
after_timestampset_period
Datum after_timestampset_period(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1567
after_timestamp_periodset
Datum after_timestamp_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1490
contained_period_periodset
Datum contained_period_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is contained by the second one.
Definition: timeops.c:724
overbefore_period_periodset
Datum overbefore_period_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:2069
minus_timestamp_periodset
Datum minus_timestamp_periodset(PG_FUNCTION_ARGS)
Returns the difference of the two time values.
Definition: timeops.c:3738
union_periodset_timestamp
Datum union_periodset_timestamp(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:3137
contains_period_timestampset_internal
bool contains_period_timestampset_internal(const Period *p, const TimestampSet *ts)
Returns true if the first time value contains the second one (internal function)
Definition: timeops.c:370
before_timestamp_periodset_internal
bool before_timestamp_periodset_internal(TimestampTz t, const PeriodSet *ps)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1098
overafter_periodset_timestampset
Datum overafter_periodset_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2499
adjacent_period_timestampset
Datum adjacent_period_timestampset(PG_FUNCTION_ARGS)
Returns true if the two time value are adjacent.
Definition: timeops.c:2700
overbefore_timestampset_periodset_internal
bool overbefore_timestampset_periodset_internal(const TimestampSet *ts, const PeriodSet *ps)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:1961
contained_timestampset_timestampset
Datum contained_timestampset_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is contained by the second one.
Definition: timeops.c:658
contained_timestamp_timestampset
Datum contained_timestamp_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is contained by the second one.
Definition: timeops.c:618
minus_period_periodset
Datum minus_period_periodset(PG_FUNCTION_ARGS)
Returns the difference of the two time values.
Definition: timeops.c:4132
adjacent_timestampset_period
Datum adjacent_timestampset_period(PG_FUNCTION_ARGS)
Returns true if the two time value are adjacent.
Definition: timeops.c:2641
after_timestamp_period_internal
bool after_timestamp_period_internal(TimestampTz t, const Period *p)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1456
union_timestampset_timestamp
Datum union_timestampset_timestamp(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:2958
contains_timestampset_timestamp
Datum contains_timestampset_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value contains the second one.
Definition: timeops.c:283
overafter_timestamp_period
Datum overafter_timestamp_period(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2226
before_period_timestampset
Datum before_period_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1262
minus_periodset_period_internal
PeriodSet * minus_periodset_period_internal(const PeriodSet *ps, const Period *p)
Returns the difference of the two time values (internal function)
Definition: timeops.c:4316
intersection_period_period
Datum intersection_period_period(PG_FUNCTION_ARGS)
Returns the intersection of the two time values (internal function)
Definition: timeops.c:3514
contains_timestampset_timestampset_internal
bool contains_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2)
Returns true if the first time value contains the second one (internal function)
Definition: timeops.c:296
before_periodset_timestamp_internal
bool before_periodset_timestamp_internal(const PeriodSet *ps, TimestampTz t)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1324
intersection_period_periodset
Datum intersection_period_periodset(PG_FUNCTION_ARGS)
Returns the intersection of the two time values.
Definition: timeops.c:3562
overlaps_period_timestampset
Datum overlaps_period_timestampset(PG_FUNCTION_ARGS)
Returns true if the two time values overlap.
Definition: timeops.c:889
after_period_timestamp
Datum after_period_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1619
overlaps_timestampset_timestampset
Datum overlaps_timestampset_timestampset(PG_FUNCTION_ARGS)
Returns true if the two time values overlap.
Definition: timeops.c:798
after_periodset_period_internal
bool after_periodset_period_internal(const PeriodSet *ps, const Period *p)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1756
contains_periodset_periodset_internal
bool contains_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2)
Returns true if the first time value contains the second one (internal function)
Definition: timeops.c:556
DURING
Definition: timeops.h:51
before_periodset_period
Datum before_periodset_period(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1387
contains_timestampset_timestamp_internal
bool contains_timestampset_timestamp_internal(const TimestampSet *ts, TimestampTz t)
Returns true if the first time value contains the second one (internal function)
Definition: timeops.c:267
overafter_timestampset_timestampset_internal
bool overafter_timestampset_timestampset_internal(const TimestampSet *ts1, const TimestampSet *ts2)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2288
minus_period_period
Datum minus_period_period(PG_FUNCTION_ARGS)
Returns the difference of the two time values (internal function)
Definition: timeops.c:4060
overlaps_period_periodset_internal
bool overlaps_period_periodset_internal(const Period *p, const PeriodSet *ps)
Returns true if the two time values overlap (internal function)
Definition: timeops.c:930
union_timestampset_timestampset
Datum union_timestampset_timestampset(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:2981
adjacent_periodset_timestampset
Datum adjacent_periodset_timestampset(PG_FUNCTION_ARGS)
Returns true if the two time value are adjacent.
Definition: timeops.c:2784
overlaps_periodset_period
Datum overlaps_periodset_period(PG_FUNCTION_ARGS)
Returns true if the two time values overlap.
Definition: timeops.c:985
before_timestamp_period_internal
bool before_timestamp_period_internal(TimestampTz t, const Period *p)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1075
overbefore_timestamp_period_internal
bool overbefore_timestamp_period_internal(TimestampTz t, const Period *p)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:1836
adjacent_period_period_internal
bool adjacent_period_period_internal(const Period *p1, const Period *p2)
Returns true if the two time value are adjacent (internal function)
Definition: timeops.c:2713
intersection_timestampset_timestampset
Datum intersection_timestampset_timestampset(PG_FUNCTION_ARGS)
Returns the intersection of the two time values.
Definition: timeops.c:3391
adjacent_periodset_period_internal
bool adjacent_periodset_period_internal(const PeriodSet *ps, const Period *p)
union_timestamp_timestampset_internal
TimestampSet * union_timestamp_timestampset_internal(TimestampTz t, const TimestampSet *ts)
Returns the union of the two time values (internal function)
Definition: timeops.c:2880
intersection_timestampset_timestamp
Datum intersection_timestampset_timestamp(PG_FUNCTION_ARGS)
Returns the intersection of the two time values.
Definition: timeops.c:3365
before_timestamp_period
Datum before_timestamp_period(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1086
overbefore_timestampset_period_internal
bool overbefore_timestampset_period_internal(const TimestampSet *ts, const Period *p)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:1936
intersection_period_period_internal
Period * intersection_period_period_internal(const Period *p1, const Period *p2)
Returns the intersection of the two time values (internal function)
Definition: timeops.c:3494
union_timestampset_period
Datum union_timestampset_period(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:2996
after_period_period
Datum after_period_period(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1667
contains_timestampset_timestampset
Datum contains_timestampset_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value contains the second one.
Definition: timeops.c:327
overlaps_timestampset_periodset_internal
bool overlaps_timestampset_periodset_internal(const TimestampSet *ts, const PeriodSet *ps)
Returns true if the two time values overlap (internal function)
Definition: timeops.c:846
union_timestamp_period
Datum union_timestamp_period(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:2925
adjacent_timestampset_period_internal
bool adjacent_timestampset_period_internal(const TimestampSet *ts, const Period *p)
Returns true if the two time value are adjacent (internal function)
Definition: timeops.c:2624
overbefore_periodset_timestampset
Datum overbefore_periodset_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:2120
before_timestampset_periodset
Datum before_timestampset_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1212
overbefore_timestamp_periodset
Datum overbefore_timestamp_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:1870
overbefore_periodset_period_internal
bool overbefore_periodset_period_internal(const PeriodSet *ps, const Period *p)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:2135
overbefore_timestampset_periodset
Datum overbefore_timestampset_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:1973
intersection_timestamp_periodset
Datum intersection_timestamp_periodset(PG_FUNCTION_ARGS)
Returns the intersection of the two time values.
Definition: timeops.c:3349
pos_timestamp_timestamp
RelativeTimePos pos_timestamp_timestamp(TimestampTz t1, TimestampTz t2)
Determine the relative position of the two timestamps.
Definition: timeops.c:73
intersection_timestampset_period
Datum intersection_timestampset_period(PG_FUNCTION_ARGS)
Returns the intersection of the two time values (internal function)
Definition: timeops.c:3417
before_timestampset_period
Datum before_timestampset_period(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1186
after_timestamp_period
Datum after_timestamp_period(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1467
minus_timestampset_periodset
Datum minus_timestampset_periodset(PG_FUNCTION_ARGS)
Returns the difference of the two time values.
Definition: timeops.c:3857
before_timestampset_periodset_internal
bool before_timestampset_periodset_internal(const TimestampSet *ts, const PeriodSet *ps)
Returns true if the first time value is strictly before the second one (internal function) ...
Definition: timeops.c:1200
after_period_periodset_internal
bool after_period_periodset_internal(const Period *p, const PeriodSet *ps)
Returns true if the first time value is strictly after the second one (internal function) ...
Definition: timeops.c:1679
union_periodset_periodset_internal
PeriodSet * union_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2)
Returns the union of the two time values (internal function)
Definition: timeops.c:3183
contains_periodset_periodset
Datum contains_periodset_periodset(PG_FUNCTION_ARGS)
Returns true if the first time value contains the second one.
Definition: timeops.c:600
overbefore_periodset_timestamp
Datum overbefore_periodset_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:2094
overafter_periodset_timestamp_internal
bool overafter_periodset_timestamp_internal(const PeriodSet *ps, TimestampTz t)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2462
minus_timestampset_timestampset
Datum minus_timestampset_timestampset(PG_FUNCTION_ARGS)
Returns the difference of the two time values.
Definition: timeops.c:3804
overbefore_periodset_timestamp_internal
bool overbefore_periodset_timestamp_internal(const PeriodSet *ps, TimestampTz t)
Returns true if the first time value is not after the second one (internal function) ...
Definition: timeops.c:2083
union_period_period
Datum union_period_period(PG_FUNCTION_ARGS)
Returns the union of the two time values.
Definition: timeops.c:3095
pos_period_timestamp
RelativeTimePos pos_period_timestamp(const Period *p, TimestampTz t)
Determine the relative position of the period and the timestamp.
Definition: timeops.c:87
AFTER
Definition: timeops.h:52
contains_period_timestampset
Datum contains_period_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value contains the second one.
Definition: timeops.c:384
overafter_periodset_timestamp
Datum overafter_periodset_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2473
overbefore_timestampset_timestampset
Datum overbefore_timestampset_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is not after the second one.
Definition: timeops.c:1921
overlaps_period_period_internal
bool overlaps_period_period_internal(const Period *p1, const Period *p2)
Returns true if the two time values overlap (internal function)
Definition: timeops.c:902
overafter_period_timestampset_internal
bool overafter_period_timestampset_internal(const Period *p, const TimestampSet *ts)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2389
contains_periodset_timestampset_internal
bool contains_periodset_timestampset_internal(const PeriodSet *ps, const TimestampSet *ts)
Returns true if the first time value contains the second one (internal function)
Definition: timeops.c:456
minus_period_timestampset_internal
PeriodSet * minus_period_timestampset_internal(const Period *p, const TimestampSet *ts)
Returns the difference of the two time values (internal function)
Definition: timeops.c:3941
overafter_periodset_periodset_internal
bool overafter_periodset_periodset_internal(const PeriodSet *ps1, const PeriodSet *ps2)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2539
overlaps_periodset_periodset
Datum overlaps_periodset_periodset(PG_FUNCTION_ARGS)
Returns true if the two time values overlap (internal function)
Definition: timeops.c:1032
contains_periodset_timestamp_internal
bool contains_periodset_timestamp_internal(const PeriodSet *ps, TimestampTz t)
Returns true if the first time value contains the second one (internal function)
Definition: timeops.c:425
overafter_period_period_internal
bool overafter_period_period_internal(const Period *p1, const Period *p2)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2414
overafter_timestamp_timestampset_internal
bool overafter_timestamp_timestampset_internal(TimestampTz t, const TimestampSet *ts)
Returns true if the first time value is not before the second one (internal function) ...
Definition: timeops.c:2190
before_period_timestamp
Datum before_period_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly before the second one.
Definition: timeops.c:1239
adjacent_period_timestamp_internal
bool adjacent_period_timestamp_internal(const Period *p, TimestampTz t)
minus_period_period_internal
PeriodSet * minus_period_period_internal(const Period *p1, const Period *p2)
Returns the difference of the two time values (internal function)
Definition: timeops.c:4042
after_periodset_timestampset
Datum after_periodset_timestampset(PG_FUNCTION_ARGS)
Returns true if the first time value is strictly after the second one.
Definition: timeops.c:1741
adjacent_period_timestamp
Datum adjacent_period_timestamp(PG_FUNCTION_ARGS)
Returns true if the two time value are adjacent.
Definition: timeops.c:2688
BEFORE
Definition: timeops.h:50
intersection_periodset_periodset
Datum intersection_periodset_periodset(PG_FUNCTION_ARGS)
Returns the intersection of the two time values.
Definition: timeops.c:3670
adjacent_period_periodset
Datum adjacent_period_periodset(PG_FUNCTION_ARGS)
Returns true if the two time value are adjacent.
Definition: timeops.c:2756
overafter_timestampset_timestamp
Datum overafter_timestampset_timestamp(PG_FUNCTION_ARGS)
Returns true if the first time value is not before the second one.
Definition: timeops.c:2274
Generated by   doxygen 1.8.13