 |
MobilityDB 1.3
|
Loading...
Searching...
No Matches
|
MobilityDB 1.3
|
General functions for span set types composed of a set of disjoint spans. More...
#include <assert.h>#include <postgres.h>#include <access/heaptoast.h>#include <access/detoast.h>#include <utils/timestamp.h>#include <meos.h>#include <meos_internal.h>#include "temporal/set.h"#include "temporal/span.h"#include "temporal/temporal.h"#include "temporal/type_inout.h"#include "temporal/type_util.h"#include "pg_temporal/meos_catalog.h"#include "pg_temporal/span.h"#include "pg_temporal/temporal.h"#include "pg_temporal/type_util.h"Functions | |
| Datum | Datespanset_date_n (PG_FUNCTION_ARGS) |
| Return the n-th date of a span set @sqlfn dateN() More... | |
| Datum | Datespanset_dates (PG_FUNCTION_ARGS) |
| Return the set of dates of a span set @sqlfn dates() More... | |
| Datum | Datespanset_duration (PG_FUNCTION_ARGS) |
| Return the duration of a date span set @sqlfn duration() More... | |
| Datum | Datespanset_end_date (PG_FUNCTION_ARGS) |
| Return the end date of a span set @sqlfn endDate() More... | |
| Datum | Datespanset_num_dates (PG_FUNCTION_ARGS) |
| Return the number of dates of a span set @sqlfn numDates() More... | |
| Datum | Datespanset_start_date (PG_FUNCTION_ARGS) |
| Return the start date of a span set @sqlfn startDate() More... | |
| Datum | Datespanset_to_tstzspanset (PG_FUNCTION_ARGS) |
| Convert a date span set into a timestamptz span set @sqlfn tstzspanset() More... | |
| Datum | Floatspanset_ceil (PG_FUNCTION_ARGS) |
| Return a float span set rounded up to the nearest integer @sqlfn ceil() More... | |
| Datum | Floatspanset_degrees (PG_FUNCTION_ARGS) |
| Return a float span set with the values converted to degrees @sqlfn degrees() More... | |
| Datum | Floatspanset_floor (PG_FUNCTION_ARGS) |
| Return a float span set rounded down to the nearest integer @sqlfn floor() More... | |
| Datum | Floatspanset_radians (PG_FUNCTION_ARGS) |
| Return a float set with the values converted to radians @sqlfn radians() More... | |
| Datum | Floatspanset_round (PG_FUNCTION_ARGS) |
| Return a float span set with the precision of the values set to a number of decimal places @sqlfn round() More... | |
| Datum | Floatspanset_to_intspanset (PG_FUNCTION_ARGS) |
| Convert a float span set into an integer spanset @sqlfn intspanset() More... | |
| Datum | Intspanset_to_floatspanset (PG_FUNCTION_ARGS) |
| Convert an integer span set into a float spanset @sqlfn floatspanset() More... | |
| Datum | Numspanset_scale (PG_FUNCTION_ARGS) |
| Return a number span set scaled by a value. More... | |
| Datum | Numspanset_shift (PG_FUNCTION_ARGS) |
| Return a number span set shifted by a value. More... | |
| Datum | Numspanset_shift_scale (PG_FUNCTION_ARGS) |
| Return a number span set shifted and scaled by two values. More... | |
| Datum | Numspanset_width (PG_FUNCTION_ARGS) |
| Return the width of a number span set @sqlfn width() More... | |
| Datum | Set_to_spanset (PG_FUNCTION_ARGS) |
| Convert a set into a span set @sqlfn intspanset(), floatspanset(), ... More... | |
| Datum | Span_to_spanset (PG_FUNCTION_ARGS) |
| Convert a span into a span set @sqlfn instspanset(), floatspanset(), ... More... | |
| Datum | Spanset_as_hexwkb (PG_FUNCTION_ARGS) |
| Return the ASCII hex-encoded Well-Known Binary (HexWKB) representation of a span set @sqlfn asHexWKB() More... | |
| Datum | Spanset_as_text (PG_FUNCTION_ARGS) |
| Return the Well-Known Text (WKT) representation of a span set @sqlfn asText() More... | |
| Datum | Spanset_as_wkb (PG_FUNCTION_ARGS) |
| Return the Well-Known Binary (WKB) representation of a span set @sqlfn asBinary() More... | |
| Datum | Spanset_cmp (PG_FUNCTION_ARGS) |
| Return -1, 0, or 1 depending on whether the first span set is less than, equal to, or greater than the second one @sqlfn spanset_cmp() More... | |
| Datum | Spanset_constructor (PG_FUNCTION_ARGS) |
| Return a span set from an array of spans @sqlfn spanset() More... | |
| Datum | Spanset_end_span (PG_FUNCTION_ARGS) |
| Return the end span of a span set @sqlfn endSpan() More... | |
| Datum | Spanset_eq (PG_FUNCTION_ARGS) |
| Return true if the first span set is equal to the second one @sqlfn spanset_eq() More... | |
| Datum | Spanset_from_hexwkb (PG_FUNCTION_ARGS) |
| Return a span set from its ASCII hex-encoded Well-Known Binary (HexWKB) representation @sqlfn intspansetFromHexWKB(), floatspansetFromHexWKB(), ... More... | |
| Datum | Spanset_from_wkb (PG_FUNCTION_ARGS) |
| Return a span set from its Well-Known Binary (WKB) representation @sqlfn instspansetFromBinary(), floatspansetFromBinary(), ... More... | |
| Datum | Spanset_ge (PG_FUNCTION_ARGS) |
| Return true if the first span set is greater than or equal to the second one @sqlfn spanset_ge() More... | |
| Datum | Spanset_gt (PG_FUNCTION_ARGS) |
| Return true if the first span set is greater than the second one @sqlfn spanset_gt() More... | |
| Datum | Spanset_hash (PG_FUNCTION_ARGS) |
| Return the 32-bit hash value of a span set @sqlfn spanset_hash() More... | |
| Datum | Spanset_hash_extended (PG_FUNCTION_ARGS) |
| Return the 64-bit hash value of a span set using a seed @sqlfn spanset_hash_extended() More... | |
| Datum | Spanset_in (PG_FUNCTION_ARGS) |
| Return a span set from its Well-Known Text (WKT) representation @sqlfn spanset_in() More... | |
| Datum | Spanset_le (PG_FUNCTION_ARGS) |
| Return true if the first span set is less than or equal to the second one @sqlfn spanset_le() More... | |
| Datum | Spanset_lower (PG_FUNCTION_ARGS) |
| Return the lower bound of a span set @sqlfn lower() More... | |
| Datum | Spanset_lower_inc (PG_FUNCTION_ARGS) |
| Return true if the lower bound of a span set is inclusive @sqlfn lower_inc() More... | |
| Datum | Spanset_lt (PG_FUNCTION_ARGS) |
| Return true if the first span set is less than the second one @sqlfn spanset_lt() More... | |
| Datum | Spanset_mem_size (PG_FUNCTION_ARGS) |
| Return the memory size in bytes of a span set @sqlfn memSize() More... | |
| Datum | Spanset_ne (PG_FUNCTION_ARGS) |
| Return true if the first span set is different from the second one @sqlfn spanset_ne() More... | |
| Datum | Spanset_num_spans (PG_FUNCTION_ARGS) |
| Return the number of spans of a span set @sqlfn numSpans() More... | |
| Datum | Spanset_out (PG_FUNCTION_ARGS) |
| Return the Well-Known Text (WKT) representation of a span set @sqlfn spanset_out() More... | |
| Datum | Spanset_recv (PG_FUNCTION_ARGS) |
| Return a span set from its Well-Known Binary (WKB) representation @sqlfn spanset_recv() More... | |
| Datum | Spanset_send (PG_FUNCTION_ARGS) |
| Return the Well-Known Binary (WKB) representation of a span set @sqlfn spanset_send() More... | |
| Datum | Spanset_span_n (PG_FUNCTION_ARGS) |
| Return the n-th span of a span set @sqlfn spanN() More... | |
| void | spanset_span_slice (Datum d, Span *s) |
| Peek into a span set datum to find the bounding box. 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... | |
| Datum | Spanset_start_span (PG_FUNCTION_ARGS) |
| Return the start span of a span set @sqlfn startSpan() More... | |
| Datum | Spanset_to_span (PG_FUNCTION_ARGS) |
| Convert a span set into a span @sqlfn span() More... | |
| Datum | Spanset_upper (PG_FUNCTION_ARGS) |
| Return the upper bound of a span set @sqlfn upper() More... | |
| Datum | Spanset_upper_inc (PG_FUNCTION_ARGS) |
| Return true if the upper bound of a span set is inclusive @sqlfn lower_inc() More... | |
| Datum | Tstzspanset_duration (PG_FUNCTION_ARGS) |
| Return the duration of a timestamptz span set @sqlfn duration() More... | |
| Datum | Tstzspanset_end_timestamptz (PG_FUNCTION_ARGS) |
| Return the end timestamptz of a span set @sqlfn endTimestamp() More... | |
| Datum | Tstzspanset_num_timestamps (PG_FUNCTION_ARGS) |
| Return the number of timestamptz values of a span set @sqlfn numTimestamps() More... | |
| Datum | Tstzspanset_scale (PG_FUNCTION_ARGS) |
| Return a timestamptz span set scaled by an interval @sqlfn scale() More... | |
| Datum | Tstzspanset_shift (PG_FUNCTION_ARGS) |
| Return a timestamptz span set shifted by an interval @sqlfn shift() More... | |
| Datum | Tstzspanset_shift_scale (PG_FUNCTION_ARGS) |
| Return a timestamptz span set shifted and scaled by two intervals @sqlfn shiftTscale() More... | |
| Datum | Tstzspanset_start_timestamptz (PG_FUNCTION_ARGS) |
| Return the start timestamptz of a span set @sqlfn startTimestamp() More... | |
| Datum | Tstzspanset_timestamps (PG_FUNCTION_ARGS) |
| Return the array of timestamptz values of a span set @sqlfn timestamps() More... | |
| Datum | Tstzspanset_timestamptz_n (PG_FUNCTION_ARGS) |
| Return the n-th timestamptz of a span set @sqlfn timestampN() More... | |
| Datum | Tstzspanset_to_datespanset (PG_FUNCTION_ARGS) |
| Convert a timestamptz span set into a date span set @sqlfn datespanset() More... | |
| Datum | Value_to_spanset (PG_FUNCTION_ARGS) |
| Convert a value into a span set @sqlfn intspanset(), floatspanset(), ... More... | |
General functions for span set types composed of a set of disjoint spans.
1.9.5