Operators for time types. More...
#include "general/timeops.h"#include <assert.h>#include <utils/timestamp.h>#include "general/period.h"#include "general/periodset.h"#include "general/timestampset.h"#include "general/tempcache.h"#include "general/temporal_util.h"
Include dependency graph for timeops.c:
Enumerations | |
| enum | SetOper { UNION, INTER, MINUS } |
Functions | |
| void | ensure_time_type_oid (Oid timetypid) |
| Ensure that the Oid corresponds to a time type. More... | |
| RelativeTimePos | pos_timestamp_timestamp (TimestampTz t1, TimestampTz t2) |
| Determine the relative position of the two timestamps. More... | |
| RelativeTimePos | pos_period_timestamp (const Period *p, TimestampTz t) |
| Determine the relative position of the period and the timestamp. More... | |
| TimestampSet * | setop_timestampset_timestampset (const TimestampSet *ts1, const TimestampSet *ts2, SetOper setop) |
| Returns the union, intersection or difference of the two time values. More... | |
| TimestampSet * | setop_timestampset_period (const TimestampSet *ts, const Period *p, SetOper setop) |
| Returns the intersection or the difference of the two time values. More... | |
| TimestampSet * | setop_timestampset_periodset (const TimestampSet *ts, const PeriodSet *ps, SetOper setop) |
| bool | contains_timestampset_timestamp_internal (const TimestampSet *ts, TimestampTz t) |
| Returns true if the first time value contains the second one (internal function) More... | |
| PGDLLEXPORT Datum | contains_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| bool | contains_timestampset_timestampset_internal (const TimestampSet *ts1, const TimestampSet *ts2) |
| Returns true if the first time value contains the second one (internal function) More... | |
| PGDLLEXPORT Datum | contains_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| bool | contains_period_timestamp_internal (const Period *p, TimestampTz t) |
| Returns true if the first time value contains the second one (internal function) More... | |
| PGDLLEXPORT Datum | contains_period_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| bool | contains_period_timestampset_internal (const Period *p, const TimestampSet *ts) |
| Returns true if the first time value contains the second one (internal function) More... | |
| PGDLLEXPORT Datum | contains_period_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| bool | contains_period_period_internal (const Period *p1, const Period *p2) |
| Returns true if the first time value contains the second one (internal function) More... | |
| PGDLLEXPORT Datum | contains_period_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| bool | contains_periodset_timestamp_internal (const PeriodSet *ps, TimestampTz t) |
| Returns true if the first time value contains the second one (internal function) More... | |
| PGDLLEXPORT Datum | contains_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| bool | contains_periodset_timestampset_internal (const PeriodSet *ps, const TimestampSet *ts) |
| Returns true if the first time value contains the second one (internal function) More... | |
| PGDLLEXPORT Datum | contains_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| bool | contains_periodset_period_internal (const PeriodSet *ps, const Period *p) |
| Returns true if the first time value contains the second one (internal function) More... | |
| PGDLLEXPORT Datum | contains_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| bool | contains_period_periodset_internal (const Period *p, const PeriodSet *ps) |
| Returns true if the first time value contains the second one (internal function) More... | |
| PGDLLEXPORT Datum | contains_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| bool | contains_periodset_periodset_internal (const PeriodSet *ps1, const PeriodSet *ps2) |
| Returns true if the first time value contains the second one (internal function) More... | |
| PGDLLEXPORT Datum | contains_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| PGDLLEXPORT Datum | contained_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| PGDLLEXPORT Datum | contained_timestamp_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| PGDLLEXPORT Datum | contained_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| PGDLLEXPORT Datum | contained_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| PGDLLEXPORT Datum | contained_timestampset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| PGDLLEXPORT Datum | contained_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | contained_period_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| PGDLLEXPORT Datum | contained_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| PGDLLEXPORT Datum | contained_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| PGDLLEXPORT Datum | contained_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| bool | overlaps_timestampset_timestampset_internal (const TimestampSet *ts1, const TimestampSet *ts2) |
| Returns true if the two time values overlap (internal function) More... | |
| PGDLLEXPORT Datum | overlaps_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap. More... | |
| bool | overlaps_timestampset_period_internal (const TimestampSet *ts, const Period *p) |
| Returns true if the two time values overlap (internal function) More... | |
| PGDLLEXPORT Datum | overlaps_timestampset_period (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap. More... | |
| bool | overlaps_timestampset_periodset_internal (const TimestampSet *ts, const PeriodSet *ps) |
| Returns true if the two time values overlap (internal function) More... | |
| PGDLLEXPORT Datum | overlaps_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap. More... | |
| PGDLLEXPORT Datum | overlaps_period_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap. More... | |
| bool | overlaps_period_period_internal (const Period *p1, const Period *p2) |
| Returns true if the two time values overlap (internal function) More... | |
| PGDLLEXPORT Datum | overlaps_period_period (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap. More... | |
| bool | overlaps_period_periodset_internal (const Period *p, const PeriodSet *ps) |
| Returns true if the two time values overlap (internal function) More... | |
| PGDLLEXPORT Datum | overlaps_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap. More... | |
| PGDLLEXPORT Datum | overlaps_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap. More... | |
| PGDLLEXPORT Datum | overlaps_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap. More... | |
| bool | overlaps_periodset_periodset_internal (const PeriodSet *ps1, const PeriodSet *ps2) |
| Returns true if the two time values overlap (internal function) More... | |
| PGDLLEXPORT Datum | overlaps_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap (internal function) More... | |
| bool | before_timestamp_timestampset_internal (const TimestampTz t, const TimestampSet *ts) |
| Returns true if the first time value is strictly before the second one (internal function) More... | |
| PGDLLEXPORT Datum | before_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| bool | before_timestamp_period_internal (const TimestampTz t, const Period *p) |
| Returns true if the first time value is strictly before the second one (internal function) More... | |
| PGDLLEXPORT Datum | before_timestamp_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| bool | before_timestamp_periodset_internal (const TimestampTz t, const PeriodSet *ps) |
| Returns true if the first time value is strictly before the second one (internal function) More... | |
| PGDLLEXPORT Datum | before_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | before_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | before_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | before_timestampset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | before_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | before_period_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | before_period_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | before_period_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | before_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| bool | before_periodset_timestamp_internal (const PeriodSet *ps, const TimestampTz t) |
| Returns true if the first time value is strictly before the second one (internal function) More... | |
| PGDLLEXPORT Datum | before_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | before_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | before_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | before_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| bool | after_timestamp_timestampset_internal (const TimestampTz t, const TimestampSet *ts) |
| Returns true if the first time value is strictly after the second one (internal function) More... | |
| PGDLLEXPORT Datum | after_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| bool | after_timestamp_period_internal (const TimestampTz t, const Period *p) |
| Returns true if the first time value is strictly after the second one (internal function) More... | |
| PGDLLEXPORT Datum | after_timestamp_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| bool | after_timestamp_periodset_internal (const TimestampTz t, const PeriodSet *ps) |
| Returns true if the first time value is strictly after the second one (internal function) More... | |
| PGDLLEXPORT Datum | after_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | after_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | after_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | after_timestampset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | after_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | after_period_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | after_period_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | after_period_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | after_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | after_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | after_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | after_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | after_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| bool | overbefore_timestamp_timestampset_internal (const TimestampTz t, const TimestampSet *ts) |
| Returns true if the first time value is not after the second one (internal function) More... | |
| PGDLLEXPORT Datum | overbefore_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| bool | overbefore_timestamp_period_internal (const TimestampTz t, const Period *p) |
| Returns true if the first time value is not after the second one (internal function) More... | |
| PGDLLEXPORT Datum | overbefore_timestamp_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| bool | overbefore_timestamp_periodset_internal (const TimestampTz t, const PeriodSet *ps) |
| Returns true if the first time value is not after the second one (internal function) More... | |
| PGDLLEXPORT Datum | overbefore_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overbefore_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overbefore_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overbefore_timestampset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overbefore_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overbefore_period_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overbefore_period_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overbefore_period_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overbefore_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overbefore_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overbefore_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overbefore_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overbefore_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| bool | overafter_timestamp_timestampset_internal (const TimestampTz t, const TimestampSet *ts) |
| Returns true if the first time value is not before the second one (internal function) More... | |
| PGDLLEXPORT Datum | overafter_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| bool | overafter_timestamp_period_internal (const TimestampTz t, const Period *p) |
| Returns true if the first time value is not before the second one (internal function) More... | |
| PGDLLEXPORT Datum | overafter_timestamp_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| bool | overafter_timestamp_periodset_internal (const TimestampTz t, const PeriodSet *ps) |
| Returns true if the first time value is not before the second one (internal function) More... | |
| PGDLLEXPORT Datum | overafter_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overafter_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overafter_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overafter_timestampset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overafter_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overafter_period_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overafter_period_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overafter_period_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overafter_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overafter_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overafter_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overafter_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| 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) More... | |
| PGDLLEXPORT Datum | overafter_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| bool | adjacent_timestamp_period_internal (const TimestampTz t, const Period *p) |
| Returns true if the two time value are adjacent (internal function) More... | |
| PGDLLEXPORT Datum | adjacent_timestamp_period (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| bool | adjacent_timestamp_periodset_internal (const TimestampTz t, const PeriodSet *ps) |
| Returns true if the two time value are adjacent (internal function) More... | |
| PGDLLEXPORT Datum | adjacent_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| bool | adjacent_timestampset_period_internal (const TimestampSet *ts, const Period *p) |
| Returns true if the two time value are adjacent (internal function) More... | |
| PGDLLEXPORT Datum | adjacent_timestampset_period (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| bool | adjacent_timestampset_periodset_internal (const TimestampSet *ts, const PeriodSet *ps) |
| Returns true if the two time value are adjacent (internal function) More... | |
| PGDLLEXPORT Datum | adjacent_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| PGDLLEXPORT Datum | adjacent_period_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| PGDLLEXPORT Datum | adjacent_period_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| bool | adjacent_period_period_internal (const Period *p1, const Period *p2) |
| Returns true if the two time value are adjacent (internal function) More... | |
| PGDLLEXPORT Datum | adjacent_period_period (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| bool | adjacent_period_periodset_internal (const Period *p, const PeriodSet *ps) |
| Returns true if the two time value are adjacent (internal function) More... | |
| PGDLLEXPORT Datum | adjacent_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| PGDLLEXPORT Datum | adjacent_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| PGDLLEXPORT Datum | adjacent_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| PGDLLEXPORT Datum | adjacent_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| bool | adjacent_periodset_periodset_internal (const PeriodSet *ps1, const PeriodSet *ps2) |
| Returns true if the two time value are adjacent (internal function) More... | |
| PGDLLEXPORT Datum | adjacent_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| PGDLLEXPORT Datum | union_timestamp_timestamp (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| TimestampSet * | union_timestamp_timestampset_internal (const TimestampTz t, const TimestampSet *ts) |
| Returns the union of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | union_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| PGDLLEXPORT Datum | union_timestamp_period (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| PGDLLEXPORT Datum | union_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| PGDLLEXPORT Datum | union_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| TimestampSet * | union_timestampset_timestampset_internal (const TimestampSet *ts1, const TimestampSet *ts2) |
| Returns the union of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | union_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| PGDLLEXPORT Datum | union_timestampset_period (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| PGDLLEXPORT Datum | union_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| PeriodSet * | union_period_period_internal (const Period *p1, const Period *p2) |
| Returns the union of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | union_period_timestamp (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| PGDLLEXPORT Datum | union_period_timestampset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| PGDLLEXPORT Datum | union_period_period (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| PeriodSet * | union_period_periodset_internal (const Period *p, const PeriodSet *ps) |
| Returns the union of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | union_period_periodset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| PGDLLEXPORT Datum | union_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| PGDLLEXPORT Datum | union_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| PGDLLEXPORT Datum | union_periodset_period (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| PeriodSet * | union_periodset_periodset_internal (const PeriodSet *ps1, const PeriodSet *ps2) |
| Returns the union of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | union_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| PGDLLEXPORT Datum | intersection_timestamp_timestamp (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| PGDLLEXPORT Datum | intersection_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| PGDLLEXPORT Datum | intersection_timestamp_period (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| PGDLLEXPORT Datum | intersection_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| PGDLLEXPORT Datum | intersection_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| TimestampSet * | intersection_timestampset_timestampset_internal (const TimestampSet *ts1, const TimestampSet *ts2) |
| Returns the intersection of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | intersection_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| TimestampSet * | intersection_timestampset_period_internal (const TimestampSet *ts, const Period *p) |
| Returns the intersection of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | intersection_timestampset_period (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values (internal function) More... | |
| TimestampSet * | intersection_timestampset_periodset_internal (const TimestampSet *ts, const PeriodSet *ps) |
| Returns the intersection of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | intersection_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| PGDLLEXPORT Datum | intersection_period_timestamp (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| PGDLLEXPORT Datum | intersection_period_timestampset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| Period * | intersection_period_period_internal (const Period *p1, const Period *p2) |
| Returns the intersection of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | intersection_period_period (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values (internal function) More... | |
| PeriodSet * | intersection_period_periodset_internal (const Period *p, const PeriodSet *ps) |
| Returns the intersection of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | intersection_period_periodset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| PGDLLEXPORT Datum | intersection_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| PGDLLEXPORT Datum | intersection_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| PGDLLEXPORT Datum | intersection_periodset_period (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| PeriodSet * | intersection_periodset_periodset_internal (const PeriodSet *ps1, const PeriodSet *ps2) |
| Returns the intersection of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | intersection_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| PGDLLEXPORT Datum | minus_timestamp_timestamp (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | minus_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| PGDLLEXPORT Datum | minus_timestamp_period (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| PGDLLEXPORT Datum | minus_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| TimestampSet * | minus_timestampset_timestamp_internal (const TimestampSet *ts, TimestampTz t) |
| Returns the difference of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | minus_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| TimestampSet * | minus_timestampset_timestampset_internal (const TimestampSet *ts1, const TimestampSet *ts2) |
| Returns the difference of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | minus_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| TimestampSet * | minus_timestampset_period_internal (const TimestampSet *ts, const Period *p) |
| Returns the difference of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | minus_timestampset_period (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| TimestampSet * | minus_timestampset_periodset_internal (const TimestampSet *ts, const PeriodSet *ps) |
| Returns the difference of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | minus_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| static int | minus_period_timestamp_internal1 (Period **result, const Period *p, TimestampTz t) |
| Returns the difference of the two time values (internal function) More... | |
| PeriodSet * | minus_period_timestamp_internal (const Period *p, TimestampTz t) |
| Returns the difference of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | minus_period_timestamp (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| PeriodSet * | minus_period_timestampset_internal (const Period *p, const TimestampSet *ts) |
| Returns the difference of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | minus_period_timestampset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time valuess. More... | |
| static int | minus_period_period_internal1 (Period **result, const Period *p1, const Period *p2) |
| Returns the difference of the two time values (internal function) More... | |
| PeriodSet * | minus_period_period_internal (const Period *p1, const Period *p2) |
| Returns the difference of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | minus_period_period (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values (internal function) More... | |
| static int | minus_period_periodset_internal1 (Period **result, const Period *p, const PeriodSet *ps, int from, int to) |
| Returns the difference of the two time values (internal function) More... | |
| PeriodSet * | minus_period_periodset_internal (const Period *p, const PeriodSet *ps) |
| PGDLLEXPORT Datum | minus_period_periodset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| PeriodSet * | minus_periodset_timestamp_internal (const PeriodSet *ps, TimestampTz t) |
| Returns the difference of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | minus_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| PeriodSet * | minus_periodset_timestampset_internal (const PeriodSet *ps, const TimestampSet *ts) |
| Returns the difference of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | minus_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| PeriodSet * | minus_periodset_period_internal (const PeriodSet *ps, const Period *p) |
| Returns the difference of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | minus_periodset_period (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| PeriodSet * | minus_periodset_periodset_internal (const PeriodSet *ps1, const PeriodSet *ps2) |
| Returns the difference of the two time values (internal function) More... | |
| PGDLLEXPORT Datum | minus_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values (internal function) More... | |
Detailed Description
Operators for time types.
