MobilityDB 1.3
Loading...
Searching...
No Matches
Functions

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...
 

Detailed Description

Topological functions for temporal types.