![]() |
MobilityDB 1.3
|
Topological functions for temporal types. More...
Functions | |
Datum | Adjacent_numspan_tnumber (PG_FUNCTION_ARGS) |
Return true if a number span and the value span of a temporal number are adjacent @sqlfn adjacent_bbox() More... | |
Datum | Adjacent_tbox_tnumber (PG_FUNCTION_ARGS) |
Return true if a temporal box and the bounding box of a temporal number are adjacent @sqlfn adjacent_bbox() More... | |
Datum | Adjacent_temporal_temporal (PG_FUNCTION_ARGS) |
Return true if the time spans of two temporal values are adjacent @sqlfn adjacent_bbox() More... | |
Datum | Adjacent_temporal_tstzspan (PG_FUNCTION_ARGS) |
Return true if the time span of a temporal value and a timestamptz span are adjacent @sqlfn adjacent_bbox() More... | |
Datum | Adjacent_tnumber_numspan (PG_FUNCTION_ARGS) |
Return true if the value span of a temporal number and a number span are adjacent @sqlfn adjacent_bbox() More... | |
Datum | Adjacent_tnumber_tbox (PG_FUNCTION_ARGS) |
Return true if the bounding box of a temporal number and a temporal box are adjacent @sqlfn adjacent_bbox() More... | |
Datum | Adjacent_tnumber_tnumber (PG_FUNCTION_ARGS) |
Return true if the bounding boxes of two temporal numbers are adjacent @sqlfn adjacent_bbox() More... | |
Datum | Adjacent_tstzspan_temporal (PG_FUNCTION_ARGS) |
Return true if a timestamptz span and the time span of a temporal value are adjacent @sqlfn adjacent_bbox() More... | |
Datum | Contained_numspan_tnumber (PG_FUNCTION_ARGS) |
Return true if a number span is contained in the value span of a temporal number @sqlfn contained_bbox() More... | |
Datum | Contained_tbox_tnumber (PG_FUNCTION_ARGS) |
Return true if a temporal box is contained in the bounding box of a temporal number @sqlfn contained_bbox() More... | |
Datum | Contained_temporal_temporal (PG_FUNCTION_ARGS) |
Return true if the time span of the first temporal value is contained in the one of the second temporal value @sqlfn contained_bbox() More... | |
Datum | Contained_temporal_tstzspan (PG_FUNCTION_ARGS) |
Return true if the time span of a temporal value is contained in a timestamptz span @sqlfn contained_bbox() More... | |
Datum | Contained_tnumber_numspan (PG_FUNCTION_ARGS) |
Return true if the value span of a temporal number is contained in a number span @sqlfn contained_bbox() More... | |
Datum | Contained_tnumber_tbox (PG_FUNCTION_ARGS) |
Return true if the bounding box of a temporal number is contained in a temporal box @sqlfn contained_bbox() More... | |
Datum | Contained_tnumber_tnumber (PG_FUNCTION_ARGS) |
Return true if the bounding box of the first temporal number is contained in the one of the second temporal number @sqlfn contained_bbox() More... | |
Datum | Contained_tstzspan_temporal (PG_FUNCTION_ARGS) |
Return true if a timestamptz span is contained the time span of a temporal value @sqlfn contained_bbox() More... | |
Datum | Contains_numspan_tnumber (PG_FUNCTION_ARGS) |
Return true if a number span contains the value span of a temporal number @sqlfn contains_bbox() More... | |
Datum | Contains_tbox_tnumber (PG_FUNCTION_ARGS) |
Return true if a temporal box contains the bounding box of a temporal number @sqlfn contains_bbox() More... | |
Datum | Contains_temporal_temporal (PG_FUNCTION_ARGS) |
Return true if the time span of the first temporal value contains the one of the second one @sqlfn contains_bbox() More... | |
Datum | Contains_temporal_tstzspan (PG_FUNCTION_ARGS) |
Return true if the time span of a temporal value contains a timestamptz span @sqlfn contains_bbox() More... | |
Datum | Contains_tnumber_numspan (PG_FUNCTION_ARGS) |
Return true if the value span of a temporal number contains a number span @sqlfn contains_bbox() More... | |
Datum | Contains_tnumber_tbox (PG_FUNCTION_ARGS) |
Return true if the bounding box of a temporal number contains a temporal box @sqlfn contains_bbox() More... | |
Datum | Contains_tnumber_tnumber (PG_FUNCTION_ARGS) |
Return true if the bounding box of the first temporal number contains the one of the second temporal number @sqlfn contains_bbox() More... | |
Datum | Contains_tstzspan_temporal (PG_FUNCTION_ARGS) |
Return true if a timestamptz span contains the time span of a temporal value @sqlfn contains_bbox() More... | |
Datum | Overlaps_numspan_tnumber (PG_FUNCTION_ARGS) |
Return true if a number span and the value span of a temporal number overlap @sqlfn overlaps_bbox() More... | |
Datum | Overlaps_tbox_tnumber (PG_FUNCTION_ARGS) |
Return true if a temporal box and the bounding box of a temporal number overlap @sqlfn overlaps_bbox() More... | |
Datum | Overlaps_temporal_temporal (PG_FUNCTION_ARGS) |
Return true if the time spans of two temporal values overlap @sqlfn overlaps_bbox() More... | |
Datum | Overlaps_temporal_tstzspan (PG_FUNCTION_ARGS) |
Return true if the time span of a temporal value and a timestamptz span overlap @sqlfn overlaps_bbox() More... | |
Datum | Overlaps_tnumber_numspan (PG_FUNCTION_ARGS) |
Return true if the value span of a temporal number and the number span overlap @sqlfn overlaps_bbox() More... | |
Datum | Overlaps_tnumber_tbox (PG_FUNCTION_ARGS) |
Return true if the bounding box of a temporal number and a temporal box overlap @sqlfn overlaps_bbox() More... | |
Datum | Overlaps_tnumber_tnumber (PG_FUNCTION_ARGS) |
Return true if the bounding boxes of two temporal numbers overlap @sqlfn overlaps_bbox() More... | |
Datum | Overlaps_tstzspan_temporal (PG_FUNCTION_ARGS) |
Return true if a timestamptz span and the time span of a temporal value overlap @sqlfn overlaps_bbox() More... | |
Datum | Same_numspan_tnumber (PG_FUNCTION_ARGS) |
Return true if a number span and the value span of a temporal number are equal @sqlfn same_bbox() More... | |
Datum | Same_tbox_tnumber (PG_FUNCTION_ARGS) |
Return true if a temporal box and the bounding box of a temporal number are equal in the common dimensions @sqlfn same_bbox() More... | |
Datum | Same_temporal_temporal (PG_FUNCTION_ARGS) |
Return true if the time spans of two temporal values are equal @sqlfn same_bbox() More... | |
Datum | Same_temporal_tstzspan (PG_FUNCTION_ARGS) |
Return true if the time span of a temporal value and a timestamptz span are equal @sqlfn same_bbox() More... | |
Datum | Same_tnumber_numspan (PG_FUNCTION_ARGS) |
Return true if the value span of a temporal number and a number span are equal @sqlfn same_bbox() More... | |
Datum | Same_tnumber_tbox (PG_FUNCTION_ARGS) |
Return true if the bounding box of a temporal number and a temporal box are equal in the common dimensions @sqlfn same_bbox() More... | |
Datum | Same_tnumber_tnumber (PG_FUNCTION_ARGS) |
Return true if the bounding boxes of two temporal numbers are equal @sqlfn same_bbox() More... | |
Datum | Same_tstzspan_temporal (PG_FUNCTION_ARGS) |
Return true if a timestamptz span and the time span of a temporal value are equal @sqlfn same_bbox() More... | |
Datum | Spanset_spans (PG_FUNCTION_ARGS) |
Return an array of spans from the spans of a spanset @sqlfn spans() More... | |
Datum | Spanset_split_each_n_spans (PG_FUNCTION_ARGS) |
Return an array of spans from a spanset obtained by merging a given number of successive composing spans @sqlfn splitEachNspans() More... | |
Datum | Spanset_split_n_spans (PG_FUNCTION_ARGS) |
Return an array of N spans from the spans of a spanset @sqlfn splitNspans() More... | |
Topological functions for temporal types.