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

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

Detailed Description

Accessor functions for set and span types.