Operators for time types. More...
Include dependency graph for timeops.h:
This graph shows which files directly or indirectly include this file:
Go to the source code of this file.
Enumerations | |
| enum | RelativeTimePos { BEFORE, DURING, AFTER } |
| Enumeration for the relative position of a given element into a skiplist. More... | |
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... | |
| Datum | contains_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| Datum | contains_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| Datum | contains_period_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| Datum | contains_period_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| Datum | contains_period_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| Datum | contains_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| Datum | contains_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| Datum | contains_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| Datum | contains_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| Datum | contains_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value contains the second one. More... | |
| bool | contains_timestampset_timestamp_internal (const TimestampSet *ts, TimestampTz t) |
| Returns true if the first time value contains the second one (internal function) 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... | |
| bool | contains_period_timestamp_internal (const Period *p, TimestampTz t) |
| Returns true if the first time value contains the second one (internal function) 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... | |
| 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... | |
| bool | contains_periodset_timestamp_internal (const PeriodSet *ps, TimestampTz t) |
| Returns true if the first time value contains the second one (internal function) 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... | |
| 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... | |
| 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... | |
| 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... | |
| Datum | contained_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| Datum | contained_timestamp_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| Datum | contained_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| Datum | contained_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| Datum | contained_timestampset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| Datum | contained_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| Datum | contained_period_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| Datum | contained_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| Datum | contained_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is contained by the second one. More... | |
| Datum | contained_periodset_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... | |
| Datum | overlaps_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap. More... | |
| Datum | overlaps_period_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap. More... | |
| Datum | overlaps_period_period (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap. More... | |
| Datum | overlaps_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap. More... | |
| Datum | overlaps_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap. More... | |
| Datum | overlaps_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap. More... | |
| Datum | overlaps_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the two time values overlap (internal function) More... | |
| bool | overlaps_timestampset_timestampset_internal (const TimestampSet *ts1, const TimestampSet *ts2) |
| Returns true if the two time values overlap (internal function) More... | |
| bool | overlaps_timestampset_period_internal (const TimestampSet *ts, const Period *p) |
| Returns true if the two time values overlap (internal function) More... | |
| bool | overlaps_timestampset_periodset_internal (const TimestampSet *ts, const PeriodSet *ps) |
| Returns true if the two time values overlap (internal function) More... | |
| bool | overlaps_period_period_internal (const Period *p1, const Period *p2) |
| Returns true if the two time values overlap (internal function) More... | |
| bool | overlaps_period_periodset_internal (const Period *p, const PeriodSet *ps) |
| Returns true if the two time values overlap (internal function) More... | |
| bool | overlaps_periodset_periodset_internal (const PeriodSet *ps1, const PeriodSet *ps2) |
| Returns true if the two time values overlap (internal function) More... | |
| Datum | before_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| Datum | before_timestamp_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| Datum | before_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| Datum | before_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| Datum | before_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| Datum | before_timestampset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| Datum | before_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| Datum | before_period_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| Datum | before_period_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| Datum | before_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| Datum | before_period_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| Datum | before_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| Datum | before_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| Datum | before_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| Datum | before_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly before the second one. More... | |
| 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) More... | |
| 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) More... | |
| 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) 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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) 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... | |
| 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... | |
| 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... | |
| Datum | after_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| Datum | after_timestamp_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| Datum | after_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| Datum | after_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| Datum | after_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| Datum | after_timestampset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| Datum | after_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| Datum | after_period_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| Datum | after_period_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| Datum | after_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| Datum | after_period_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| Datum | after_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| Datum | after_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| Datum | after_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| Datum | after_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is strictly after the second one. More... | |
| 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) More... | |
| 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) More... | |
| 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) 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| Datum | overbefore_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| Datum | overbefore_timestamp_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| Datum | overbefore_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| Datum | overbefore_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| Datum | overbefore_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| Datum | overbefore_timestampset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| Datum | overbefore_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| Datum | overbefore_period_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| Datum | overbefore_period_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| Datum | overbefore_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| Datum | overbefore_period_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| Datum | overbefore_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| Datum | overbefore_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| Datum | overbefore_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| Datum | overbefore_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not after the second one. More... | |
| 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) More... | |
| 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) More... | |
| 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) 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| Datum | overafter_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| Datum | overafter_timestamp_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| Datum | overafter_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| Datum | overafter_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| Datum | overafter_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| Datum | overafter_timestampset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| Datum | overafter_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| Datum | overafter_period_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| Datum | overafter_period_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| Datum | overafter_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| Datum | overafter_period_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| Datum | overafter_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| Datum | overafter_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| Datum | overafter_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| Datum | overafter_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the first time value is not before the second one. More... | |
| 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) More... | |
| 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) More... | |
| 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) 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| 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... | |
| Datum | adjacent_timestamp_period (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| Datum | adjacent_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| Datum | adjacent_timestampset_period (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| Datum | adjacent_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| Datum | adjacent_period_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| Datum | adjacent_period_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| Datum | adjacent_period_period (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| Datum | adjacent_period_periodset (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| Datum | adjacent_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| Datum | adjacent_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| Datum | adjacent_periodset_period (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| Datum | adjacent_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns true if the two time value are adjacent. More... | |
| bool | adjacent_timestamp_period_internal (TimestampTz t, const Period *p) |
| Returns true if the two time value are adjacent (internal function) More... | |
| bool | adjacent_timestamp_periodset_internal (TimestampTz t, const PeriodSet *ps) |
| Returns true if the two time value are adjacent (internal function) More... | |
| bool | adjacent_timestampset_period_internal (const TimestampSet *ts, const Period *p) |
| Returns true if the two time value are adjacent (internal function) More... | |
| bool | adjacent_timestampset_periodset_internal (const TimestampSet *ts, const PeriodSet *ps) |
| Returns true if the two time value are adjacent (internal function) More... | |
| bool | adjacent_period_timestamp_internal (const Period *p, TimestampTz t) |
| bool | adjacent_period_timestampset_internal (const Period *p, const TimestampSet *ts) |
| bool | adjacent_period_period_internal (const Period *p1, const Period *p2) |
| Returns true if the two time value are adjacent (internal function) More... | |
| bool | adjacent_period_periodset_internal (const Period *p, const PeriodSet *ps) |
| Returns true if the two time value are adjacent (internal function) More... | |
| bool | adjacent_periodset_timestamp_internal (const PeriodSet *ps, TimestampTz t) |
| bool | adjacent_periodset_timestampset_internal (const PeriodSet *ps, const TimestampSet *ts) |
| bool | adjacent_periodset_period_internal (const PeriodSet *ps, const Period *p) |
| bool | adjacent_periodset_periodset_internal (const PeriodSet *ps1, const PeriodSet *ps2) |
| Returns true if the two time value are adjacent (internal function) More... | |
| Datum | union_timestamp_timestamp (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_timestamp_period (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_timestampset_period (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_period_timestamp (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_period_timestampset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_period_period (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_period_periodset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_periodset_period (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| Datum | union_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns the union of the two time values. More... | |
| TimestampSet * | union_timestamp_timestampset_internal (TimestampTz t, const TimestampSet *ts) |
| Returns the union of the two time values (internal function) More... | |
| TimestampSet * | union_timestampset_timestampset_internal (const TimestampSet *ts1, const TimestampSet *ts2) |
| Returns the union of the two time values (internal function) More... | |
| PeriodSet * | union_period_period_internal (const Period *p1, const Period *p2) |
| Returns the union of the two time values (internal function) More... | |
| PeriodSet * | union_period_periodset_internal (const Period *p, const PeriodSet *ps) |
| Returns the union of the two time values (internal function) More... | |
| PeriodSet * | union_periodset_periodset_internal (const PeriodSet *ps1, const PeriodSet *ps2) |
| Returns the union of the two time values (internal function) More... | |
| Datum | intersection_timestamp_timestamp (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| Datum | intersection_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| Datum | intersection_timestamp_period (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| Datum | intersection_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| Datum | intersection_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| Datum | intersection_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| Datum | intersection_timestampset_period (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values (internal function) More... | |
| Datum | intersection_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| Datum | intersection_period_timestamp (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| Datum | intersection_period_timestampset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| Datum | intersection_period_period (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values (internal function) More... | |
| Datum | intersection_period_periodset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| Datum | intersection_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| Datum | intersection_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| Datum | intersection_periodset_period (PG_FUNCTION_ARGS) |
| Returns the intersection of the two time values. More... | |
| Datum | intersection_periodset_periodset (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... | |
| TimestampSet * | intersection_timestampset_period_internal (const TimestampSet *ts, const Period *p) |
| Returns the intersection of the two time values (internal function) More... | |
| Period * | intersection_period_period_internal (const Period *p1, const Period *p2) |
| 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... | |
| PeriodSet * | intersection_periodset_periodset_internal (const PeriodSet *ps1, const PeriodSet *ps2) |
| Returns the intersection of the two time values (internal function) More... | |
| Datum | minus_timestamp_timestamp (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values (internal function) More... | |
| Datum | minus_timestamp_timestampset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| Datum | minus_timestamp_period (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| Datum | minus_timestamp_periodset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| Datum | minus_timestampset_timestamp (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| Datum | minus_timestampset_timestampset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| Datum | minus_timestampset_period (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| Datum | minus_timestampset_periodset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| Datum | minus_period_timestamp (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| Datum | minus_period_timestampset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time valuess. More... | |
| Datum | minus_period_period (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values (internal function) More... | |
| Datum | minus_period_periodset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| Datum | minus_periodset_timestamp (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| Datum | minus_periodset_timestampset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| Datum | minus_periodset_period (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values. More... | |
| Datum | minus_periodset_periodset (PG_FUNCTION_ARGS) |
| Returns the difference of the two time values (internal function) More... | |
| TimestampSet * | minus_timestampset_timestamp_internal (const TimestampSet *ts, TimestampTz t) |
| Returns the difference of the two time values (internal function) More... | |
| TimestampSet * | minus_timestampset_timestampset_internal (const TimestampSet *ts1, const TimestampSet *ts2) |
| Returns the difference of the two time values (internal function) More... | |
| TimestampSet * | minus_timestampset_period_internal (const TimestampSet *ts, const Period *p) |
| Returns the difference of the two time values (internal function) More... | |
| TimestampSet * | minus_timestampset_periodset_internal (const TimestampSet *ts, const PeriodSet *ps) |
| 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... | |
| PeriodSet * | minus_period_timestampset_internal (const Period *p, const TimestampSet *ts) |
| 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... | |
| PeriodSet * | minus_period_periodset_internal (const Period *p, const PeriodSet *ps) |
| PeriodSet * | minus_periodset_timestamp_internal (const PeriodSet *ps, TimestampTz t) |
| Returns the difference of the two time values (internal function) More... | |
| PeriodSet * | minus_periodset_timestampset_internal (const PeriodSet *ps, const TimestampSet *ts) |
| Returns the difference of the two time values (internal function) More... | |
| PeriodSet * | minus_periodset_period_internal (const PeriodSet *ps, const Period *p) |
| Returns the difference of the two time values (internal function) More... | |
| PeriodSet * | minus_periodset_periodset_internal (const PeriodSet *ps1, const PeriodSet *ps2) |
| Returns the difference of the two time values (internal function) More... | |
Detailed Description
Operators for time types.
