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

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

Detailed Description

Conversion functions for set and span types.