![]() |
MobilityDB 1.3
|
Conversion functions for set and span types. More...
Functions | |
Datum | Dateset_to_tstzset (PG_FUNCTION_ARGS) |
Convert a date set into a timestamptz set @sqlfn tstzset() More... | |
Datum | Datespan_to_tstzspan (PG_FUNCTION_ARGS) |
Convert a date span into a timestamptz span @sqlfn tstzspan() More... | |
Datum | Datespanset_to_tstzspanset (PG_FUNCTION_ARGS) |
Convert a date span set into a timestamptz span set @sqlfn tstzspanset() More... | |
Datum | Floatset_to_intset (PG_FUNCTION_ARGS) |
Convert a float set into a integer set @sqlfn intset() More... | |
Datum | Floatspan_to_intspan (PG_FUNCTION_ARGS) |
Convert a float span into a integer span @sqlfn intspan() More... | |
Datum | Floatspanset_to_intspanset (PG_FUNCTION_ARGS) |
Convert a float span set into an integer spanset @sqlfn intspanset() More... | |
Datum | Intset_to_floatset (PG_FUNCTION_ARGS) |
Convert an integer set into a float set @sqlfn floatset() More... | |
Datum | Intspan_to_floatspan (PG_FUNCTION_ARGS) |
Convert an integer span into a float span @sqlfn floatspan() More... | |
Datum | Intspanset_to_floatspanset (PG_FUNCTION_ARGS) |
Convert an integer span set into a float spanset @sqlfn floatspanset() More... | |
Datum | Range_to_span (PG_FUNCTION_ARGS) |
Convert a PostgreSQL range into a span @sqlfn intspan(), tstzspan() More... | |
Datum | Set_spans (PG_FUNCTION_ARGS) |
Return an array of spans from the elements of a set @sqlfn spans() More... | |
Datum | Set_split_each_n_spans (PG_FUNCTION_ARGS) |
Return an array of spans from the elements of a set obtained by merging a given number of successive elements @sqlfn splitEachNSpans() More... | |
Datum | Set_split_n_spans (PG_FUNCTION_ARGS) |
Return an array of N spans from the elements of a set @sqlfn splitNspans() More... | |
Datum | Set_to_span (PG_FUNCTION_ARGS) |
Convert a set into a span @sqlfn span() More... | |
Datum | Set_to_spanset (PG_FUNCTION_ARGS) |
Convert a set into a span set @sqlfn intspanset(), floatspanset(), ... More... | |
Datum | Span_to_range (PG_FUNCTION_ARGS) |
Convert a span into a range @sqlfn int4range(), tstzrange() More... | |
Datum | Span_to_spanset (PG_FUNCTION_ARGS) |
Convert a span into a span set @sqlfn instspanset(), floatspanset(), ... More... | |
Datum | Spanset_to_span (PG_FUNCTION_ARGS) |
Convert a span set into a span @sqlfn span() More... | |
Datum | Tstzset_to_dateset (PG_FUNCTION_ARGS) |
Convert a timestamptz set into a date set @sqlfn dateset() More... | |
Datum | Tstzspan_to_datespan (PG_FUNCTION_ARGS) |
Convert a timestamptz span into a date span @sqlfn datespan() More... | |
Datum | Tstzspanset_to_datespanset (PG_FUNCTION_ARGS) |
Convert a timestamptz span set into a date span set @sqlfn datespanset() More... | |
Datum | Value_to_set (PG_FUNCTION_ARGS) |
Convert a base value into a set @sqlfn set() More... | |
Datum | Value_to_span (PG_FUNCTION_ARGS) |
Convert a value into a span @sqlfn span() More... | |
Datum | Value_to_spanset (PG_FUNCTION_ARGS) |
Convert a value into a span set @sqlfn intspanset(), floatspanset(), ... More... | |
Conversion functions for set and span types.