 |
MobilityDB 1.3
|
Loading...
Searching...
No Matches
|
MobilityDB 1.3
|
Functions for temporal bounding boxes. More...
#include <postgres.h>#include <fmgr.h>#include <utils/timestamp.h>#include <meos.h>#include <meos_internal.h>#include "temporal/set.h"#include "temporal/span.h"#include "temporal/tbox.h"#include "temporal/temporal.h"#include "temporal/type_inout.h"#include "temporal/type_util.h"#include "pg_temporal/meos_catalog.h"#include "pg_temporal/temporal.h"#include "pg_temporal/type_util.h"Functions | |
| Datum | Adjacent_tbox_tbox (PG_FUNCTION_ARGS) |
| Return true if two temporal boxes are adjacent @sqlfn tbox_adjacent() More... | |
| Datum | After_tbox_tbox (PG_FUNCTION_ARGS) |
| Return true if the first temporal box is after the second one @sqlfn tbox_after() More... | |
| Datum | Before_tbox_tbox (PG_FUNCTION_ARGS) |
| Return true if the first temporal box is before the second one @sqlfn tbox_before() More... | |
| Datum | Contained_tbox_tbox (PG_FUNCTION_ARGS) |
| Return true if the first temporal box is contained in the second one @sqlfn tbox_contained() More... | |
| Datum | Contains_tbox_tbox (PG_FUNCTION_ARGS) |
| Return true if the first temporal box contains the second one @sqlfn tbox_contains() More... | |
| Datum | Intersection_tbox_tbox (PG_FUNCTION_ARGS) |
| Return the intersection of two temporal boxes @sqlfn intersection() More... | |
| Datum | Left_tbox_tbox (PG_FUNCTION_ARGS) |
| Return true if the first temporal box is to the left of the second one @sqlfn tbox_left() More... | |
| Datum | Number_timestamptz_to_tbox (PG_FUNCTION_ARGS) |
| Return a temporal box constructed from a number and a timestamptz @sqlfn tbox() More... | |
| Datum | Number_to_tbox (PG_FUNCTION_ARGS) |
| Convert a number into a temporal box @sqlfn tbox() More... | |
| Datum | Number_tstzspan_to_tbox (PG_FUNCTION_ARGS) |
| Return a temporal box constructed from a number and a timestamptz span @sqlfn tbox() More... | |
| Datum | Numeric_to_tbox (PG_FUNCTION_ARGS) |
| Convert a numeric into a temporal box @sqlfn tbox() More... | |
| Datum | Numspan_timestamptz_to_tbox (PG_FUNCTION_ARGS) |
| Return a temporal box constructed from a number span and a timestamptz @sqlfn tbox() More... | |
| Datum | Numspan_tstzspan_to_tbox (PG_FUNCTION_ARGS) |
| Return a temporal box constructed from a number span and a timestamptz span @sqlfn tbox() More... | |
| Datum | Overafter_tbox_tbox (PG_FUNCTION_ARGS) |
| Return true if the first temporal box is not before the second one @sqlfn tbox_overafter() More... | |
| Datum | Overbefore_tbox_tbox (PG_FUNCTION_ARGS) |
| Return true if the first temporal box is not after the second one @sqlfn tbox_overbefore() More... | |
| Datum | Overlaps_tbox_tbox (PG_FUNCTION_ARGS) |
| Return true if two temporal boxes overlap @sqlfn tbox_overlaps() More... | |
| Datum | Overleft_tbox_tbox (PG_FUNCTION_ARGS) |
| Return true if the first temporal box does not extend to the right of the second one @sqlfn tbox_overleft() More... | |
| Datum | Overright_tbox_tbox (PG_FUNCTION_ARGS) |
| Return true if the first temporal box does not extend to the left of the second one @sqlfn tbox_overright() More... | |
| Datum | Right_tbox_tbox (PG_FUNCTION_ARGS) |
| Return true if the first temporal box is to the right of the second one @sqlfn tbox_right() More... | |
| Datum | Same_tbox_tbox (PG_FUNCTION_ARGS) |
| Return true if two temporal boxes are equal on the common dimensions @sqlfn tbox_same() More... | |
| Datum | Set_to_tbox (PG_FUNCTION_ARGS) |
| Convert a set into a temporal box @sqlfn tbox() More... | |
| Datum | Span_to_tbox (PG_FUNCTION_ARGS) |
| Convert a span into a temporal box @sqlfn tbox() More... | |
| void | spanset_tbox_slice (Datum d, TBox *box) |
| Peek into a span set datum to find the bounding box. More... | |
| Datum | Spanset_to_tbox (PG_FUNCTION_ARGS) |
| Convert a span set into a temporal box @sqlfn tbox() More... | |
| Datum | Tbox_as_hexwkb (PG_FUNCTION_ARGS) |
| Return the ASCII hex-encoded Well-Known Binary (HexWKB) representation of a temporal box @sqlfn asHexWKB() More... | |
| Datum | Tbox_as_text (PG_FUNCTION_ARGS) |
| Return the Well-Known Text (WKT) representation of a temporal box @sqlfn asText() More... | |
| Datum | Tbox_as_wkb (PG_FUNCTION_ARGS) |
| Return the Well-Known Binary (WKB) representation of a temporal box @sqlfn asBinary() More... | |
| Datum | Tbox_cmp (PG_FUNCTION_ARGS) |
| Return -1, 0, or 1 depending on whether the first temporal box is less than, equal to, or greater than the second one @sqlfn tbox_cmp() More... | |
| Datum | Tbox_eq (PG_FUNCTION_ARGS) |
| Return true if two temporal boxes are equal @sqlfn tbox_eq() More... | |
| Datum | Tbox_expand_time (PG_FUNCTION_ARGS) |
| Return a temporal box with the the time span expanded/shrinked by an interval @sqlfn expandTime() More... | |
| Datum | Tbox_expand_value (PG_FUNCTION_ARGS) |
| Return a temporal box with the value span expanded by a value @sqlfn expandValue() More... | |
| Datum | Tbox_extent_combinefn (PG_FUNCTION_ARGS) |
| Combine function for extent aggregation for temporal boxes. More... | |
| Datum | Tbox_extent_transfn (PG_FUNCTION_ARGS) |
| Transition function for extent aggregation for boxes. More... | |
| Datum | Tbox_from_hexwkb (PG_FUNCTION_ARGS) |
| Return a temporal box from its ASCII hex-encoded Well-Known Binary (HexWKB) representation @sqlfn tboxFromHexWKB() More... | |
| Datum | Tbox_from_wkb (PG_FUNCTION_ARGS) |
| Return a temporal box from its Well-Known Binary (WKB) representation @sqlfn tboxFromBinary() More... | |
| Datum | Tbox_ge (PG_FUNCTION_ARGS) |
| Return true if the first temporal box is greater than or equal to the second one @sqlfn tbox_ge() More... | |
| Datum | Tbox_gt (PG_FUNCTION_ARGS) |
| Return true if the first temporal box is greater than the second one @sqlfn tbox_gt() More... | |
| Datum | Tbox_hast (PG_FUNCTION_ARGS) |
| Return true if a temporal box has time dimension @sqlfn hasT() More... | |
| Datum | Tbox_hasx (PG_FUNCTION_ARGS) |
| Return true if a temporal box has value dimension @sqlfn hasX() More... | |
| Datum | Tbox_in (PG_FUNCTION_ARGS) |
| Return a temporal box from its Well-Known Text (WKT) representation. More... | |
| Datum | Tbox_le (PG_FUNCTION_ARGS) |
| Return true if the first temporal box is less than or equal to the second one @sqlfn tbox_le() More... | |
| Datum | Tbox_lt (PG_FUNCTION_ARGS) |
| Return true if the first temporal box is less than the second one @sqlfn tbox_lt() More... | |
| Datum | Tbox_ne (PG_FUNCTION_ARGS) |
| Return true if two temporal boxes are different @sqlfn tbox_ne() More... | |
| Datum | Tbox_out (PG_FUNCTION_ARGS) |
| Return the Well-Known Text (WKT) representation of a temporal box @sqlfn tbox_out() More... | |
| Datum | Tbox_recv (PG_FUNCTION_ARGS) |
| Return a temporal box from its Well-Known Binary (WKB) representation @sqlfn tbox_recv() More... | |
| Datum | Tbox_round (PG_FUNCTION_ARGS) |
| Return a temporal box with the precision of the value span set to a number of decimal places @sqlfn round() More... | |
| Datum | Tbox_scale_time (PG_FUNCTION_ARGS) |
| Return a temporal box with the time span scaled by an interval @sqlfn scaleTime() More... | |
| Datum | Tbox_scale_value (PG_FUNCTION_ARGS) |
| Return a temporal box with the value span scaled by a value @sqlfn scaleValue() More... | |
| Datum | Tbox_send (PG_FUNCTION_ARGS) |
| Return the Well-Known Binary (WKB) representation of a temporal box @sqlfn tbox_send() More... | |
| Datum | Tbox_shift_scale_time (PG_FUNCTION_ARGS) |
| Return a temporal box with the time span shifted and scaled by two intervals @sqlfn shiftScaleTime() More... | |
| Datum | Tbox_shift_scale_value (PG_FUNCTION_ARGS) |
| Return a temporal box with the value span shifted and scaled by two values @sqlfn scaleValue() More... | |
| Datum | Tbox_shift_time (PG_FUNCTION_ARGS) |
| Return a temporal box with the time span shifted by a value @sqlfn shiftTime() More... | |
| Datum | Tbox_shift_value (PG_FUNCTION_ARGS) |
| Return a temporal box with the value span shifted by a value @sqlfn shiftValue() More... | |
| Datum | Tbox_tmax (PG_FUNCTION_ARGS) |
| Return the maximum timestamp of a temporal box, if any @sqlfn Tmax() More... | |
| Datum | Tbox_tmax_inc (PG_FUNCTION_ARGS) |
| Return true if the maximum timestamp value of a temporal box is inclusive, if any @sqlfn Tmin_inc() More... | |
| Datum | Tbox_tmin (PG_FUNCTION_ARGS) |
| Return the minimum timestamp of a temporal box, if any @sqlfn Tmin() More... | |
| Datum | Tbox_tmin_inc (PG_FUNCTION_ARGS) |
| Return true if the minimum timestamp value of a temporal box is inclusive, if any @sqlfn Tmin_inc() More... | |
| Datum | Tbox_to_floatspan (PG_FUNCTION_ARGS) |
| Convert a temporal box into a float span @sqlfn floatspan() More... | |
| Datum | Tbox_to_intspan (PG_FUNCTION_ARGS) |
| Convert a temporal box into an integer span @sqlfn floatspan() More... | |
| Datum | Tbox_to_tstzspan (PG_FUNCTION_ARGS) |
| Convert a temporal box into a timestamptz span @sqlfn timeSpan() More... | |
| Datum | Tbox_xmax (PG_FUNCTION_ARGS) |
| Return the maximum X value of a temporal box as a double, if any @sqlfn Xmax() More... | |
| Datum | Tbox_xmax_inc (PG_FUNCTION_ARGS) |
| Return true if the maximum X value of a temporal box is inclusive, if any @sqlfn Xmin_inc() More... | |
| Datum | Tbox_xmin (PG_FUNCTION_ARGS) |
| Return the minimum X value of a temporal box, if any @sqlfn Xmin() More... | |
| Datum | Tbox_xmin_inc (PG_FUNCTION_ARGS) |
| Return true if the minimum X value of a temporal box is inclusive, if any @sqlfn Xmin_inc() More... | |
| Datum | Timestamptz_to_tbox (PG_FUNCTION_ARGS) |
| Conver a timestamptz to a temporal box @sqlfn tbox() More... | |
| Datum | Union_tbox_tbox (PG_FUNCTION_ARGS) |
| Return the union of two temporal boxes @sqlfn union() More... | |
Functions for temporal bounding boxes.
1.9.5