![]() |
MobilityDB 1.3
|
Accessor functions for set and span types. More...
Functions | |
Datum | Datespan_duration (PG_FUNCTION_ARGS) |
Return the duration of a date span @sqlfn duration() More... | |
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 | Numspan_width (PG_FUNCTION_ARGS) |
Return the width of a number span @sqlfn width() More... | |
Datum | Numspanset_width (PG_FUNCTION_ARGS) |
Return the width of a number span set @sqlfn width() More... | |
Datum | Set_end_value (PG_FUNCTION_ARGS) |
Return the end value of a set @sqlfn endValue() More... | |
Datum | Set_hash (PG_FUNCTION_ARGS) |
Return the 32-bit hash value of a set @sqlfn hash() More... | |
Datum | Set_hash_extended (PG_FUNCTION_ARGS) |
Return the 64-bit hash value of a set using a seed @sqlfn hash_extended() More... | |
Datum | Set_mem_size (PG_FUNCTION_ARGS) |
Return the memory size in bytes of a set @sqlfn memSize() More... | |
Datum | Set_num_values (PG_FUNCTION_ARGS) |
Return the number of values of a set @sqlfn numValues() More... | |
Datum | Set_start_value (PG_FUNCTION_ARGS) |
Return the start value of a set @sqlfn startValue() More... | |
Datum | Set_value_n (PG_FUNCTION_ARGS) |
Return the n-th value of a set @sqlfn valueN() More... | |
Datum | Set_values (PG_FUNCTION_ARGS) |
Return the array of values of a set @sqlfn getValues() More... | |
Datum | Span_hash (PG_FUNCTION_ARGS) |
Return the 32-bit hash value of a span @sqlfn span_hash() More... | |
Datum | Span_hash_extended (PG_FUNCTION_ARGS) |
Return the 64-bit hash value of a span using a seed @sqlfn hash_extended() More... | |
Datum | Span_lower (PG_FUNCTION_ARGS) |
Return the lower bound of a span @sqlfn lower() More... | |
Datum | Span_lower_inc (PG_FUNCTION_ARGS) |
Return true if the lower bound of a span is inclusive @sqlfn lower_inc() More... | |
Datum | Span_upper (PG_FUNCTION_ARGS) |
Return the upper bound of a span @sqlfn upper() More... | |
Datum | Span_upper_inc (PG_FUNCTION_ARGS) |
Return true if the upper bound of a span is inclusive @sqlfn lower_inc() More... | |
Datum | Spanset_end_span (PG_FUNCTION_ARGS) |
Return the end span of a span set @sqlfn endSpan() 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_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_mem_size (PG_FUNCTION_ARGS) |
Return the memory size in bytes of a span set @sqlfn memSize() More... | |
Datum | Spanset_num_spans (PG_FUNCTION_ARGS) |
Return the number of spans of a span set @sqlfn numSpans() More... | |
Datum | Spanset_span_n (PG_FUNCTION_ARGS) |
Return the n-th span of a span set @sqlfn spanN() More... | |
Datum | Spanset_start_span (PG_FUNCTION_ARGS) |
Return the start span of a span set @sqlfn startSpan() 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 | Tstzspan_duration (PG_FUNCTION_ARGS) |
Return the duration of a timestamptz span @sqlfn duration() 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_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... | |
Accessor functions for set and span types.