 |
MobilityDB 1.3
|
Loading...
Searching...
No Matches
|
MobilityDB 1.3
|
Bounding box functions for temporal types. More...
#include "temporal/temporal_boxops.h"#include <postgres.h>#include <fmgr.h>#include <meos.h>#include <meos_internal.h>#include "temporal/span.h"#include "temporal/tbox.h"#include "temporal/temporal.h"#include "pg_temporal/type_util.h"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 | Boxop_numspan_tnumber (FunctionCallInfo fcinfo, bool(*func)(const Span *, const Span *)) |
| Generic bounding box function for a span and a temporal number. More... | |
| Datum | Boxop_tbox_tnumber (FunctionCallInfo fcinfo, bool(*func)(const TBox *, const TBox *)) |
| Generic bounding box function for a temporal box and a temporal number. More... | |
| Datum | Boxop_temporal_temporal (FunctionCallInfo fcinfo, bool(*func)(const Span *, const Span *)) |
| Generic bounding box function for two temporal values. More... | |
| Datum | Boxop_temporal_tstzspan (FunctionCallInfo fcinfo, bool(*func)(const Span *, const Span *)) |
| Generic bounding box function for a temporal value and a timestamptz span. More... | |
| Datum | Boxop_tnumber_numspan (FunctionCallInfo fcinfo, bool(*func)(const Span *, const Span *)) |
| Generic bounding box function for a temporal number and a span. More... | |
| Datum | Boxop_tnumber_tbox (FunctionCallInfo fcinfo, bool(*func)(const TBox *, const TBox *)) |
| Generic bounding box function for a temporal number and a temporal box. More... | |
| Datum | Boxop_tnumber_tnumber (FunctionCallInfo fcinfo, bool(*func)(const TBox *, const TBox *)) |
| Generic bounding box function for two temporal numbers. More... | |
| Datum | Boxop_tstzspan_temporal (FunctionCallInfo fcinfo, bool(*func)(const Span *, const Span *)) |
| Generic bounding box function for a timestamptz span and a temporal value. 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 | Temporal_spans (PG_FUNCTION_ARGS) |
| Return an array of spans from a temporal value @sqlfn spans() More... | |
| Datum | Temporal_split_each_n_spans (PG_FUNCTION_ARGS) |
| Return an array of spans from the instants or segments of a temporal value, where the choice between instants or segments depends, respectively, on whether the interpolation is discrete or continuous @sqlfn splitEachNSpans() More... | |
| Datum | Temporal_split_n_spans (PG_FUNCTION_ARGS) |
| Return an array of N spans from the instants or segments of a temporal value, where the choice between instants or segments depends, respectively, on whether the interpolation is discrete or continuous @sqlfn splitNSpans() More... | |
| Datum | Tnumber_split_each_n_tboxes (PG_FUNCTION_ARGS) |
| Return an array of temporal boxes from the instants or segments of a temporal number, where the choice between instants or segments depends, respectively, on whether the interpolation is discrete or continuous @sqlfn splitEachNTboxes() More... | |
| Datum | Tnumber_split_n_tboxes (PG_FUNCTION_ARGS) |
| Return an array of N temporal boxes from the instants or segments of a temporal number, where the choice between instants or segments depends, respectively, on whether the interpolation is discrete or continuous @sqlfn splitNTboxes() More... | |
| Datum | Tnumber_tboxes (PG_FUNCTION_ARGS) |
| Return an array of temporal boxes from a temporal number @sqlfn tboxes() More... | |
Bounding box functions for temporal types.
The bounding box of temporal values are
Span for temporal Boolean and temporal text valuesTBox for temporal integers and floats, where the x coordinate is for the value dimension and the t coordinate is for the time dimension. The following functions are defined: overlaps, contains, contained, same, and adjacent.The functions consider as many dimensions as they are shared in both arguments: only the value dimension, only the time dimension, or both the value and the time dimensions.
1.9.5