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

Transformation functions for set and span types. More...

Functions

Datum Float_round (PG_FUNCTION_ARGS)
 Return a float with the precision of the values set to a number of decimal places @sqlfn round() More...
 
Datum Floatset_ceil (PG_FUNCTION_ARGS)
 Return a float set rounded up to the nearest integer @sqlfn ceil() More...
 
Datum Floatset_degrees (PG_FUNCTION_ARGS)
 Return a float set with the values converted to degrees @sqlfn degrees() More...
 
Datum Floatset_floor (PG_FUNCTION_ARGS)
 Return a float set rounded down to the nearest integer @sqlfn floor() More...
 
Datum Floatset_radians (PG_FUNCTION_ARGS)
 Return a float set with the values converted to radians @sqlfn radians() More...
 
Datum Floatspan_ceil (PG_FUNCTION_ARGS)
 Return a float span rounded up to the nearest integer @sqlfn ceil() More...
 
Datum Floatspan_degrees (PG_FUNCTION_ARGS)
 Return a float span with the values converted to degrees @sqlfn degrees() More...
 
Datum Floatspan_floor (PG_FUNCTION_ARGS)
 Return a float span rounded down to the nearest integer @sqlfn floor() More...
 
Datum Floatspan_radians (PG_FUNCTION_ARGS)
 Return a float set with the values converted to radians @sqlfn radians() More...
 
Datum Floatspan_round (PG_FUNCTION_ARGS)
 Return a float span with the precision of the values set to a number of decimal places @sqlfn round() 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 Numset_scale (PG_FUNCTION_ARGS)
 Return a number set scaled by a value @sqlfn scale() More...
 
Datum Numset_shift (PG_FUNCTION_ARGS)
 Return a number set shifted by a value @sqlfn shift() More...
 
Datum Numset_shift_scale (PG_FUNCTION_ARGS)
 Return a number set shifted and scaled by two values @sqlfn shiftScale() More...
 
Datum Numspan_expand (PG_FUNCTION_ARGS)
 Return a number span with its bounds expanded or shrinded by a value. More...
 
Datum Numspan_scale (PG_FUNCTION_ARGS)
 Return a number span scaled by a value. More...
 
Datum Numspan_shift (PG_FUNCTION_ARGS)
 Return a number span shifted by a value. More...
 
Datum Numspan_shift_scale (PG_FUNCTION_ARGS)
 Return a number span shifted and scaled by two values. 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 Set_round (PG_FUNCTION_ARGS)
 Return a set with the precision of the values set to a number of decimal places @sqlfn round() More...
 
Datum Set_unnest (PG_FUNCTION_ARGS)
 Return the list of values of a set. More...
 
Datum Textcat_text_textset (PG_FUNCTION_ARGS)
 Return a text value concatenated with a text set @sqlfn textset_cat() More...
 
Datum Textcat_textset_text (PG_FUNCTION_ARGS)
 Return a text set concatenated with a text value @sqlfn textset_cat() More...
 
Datum Textset_initcap (PG_FUNCTION_ARGS)
 Return a text set with the values transformed to initcap @sqlfn initcap() More...
 
Datum Textset_lower (PG_FUNCTION_ARGS)
 Return a text set with the values transformed to lowercase @sqlfn lower() More...
 
Datum Textset_upper (PG_FUNCTION_ARGS)
 Return a text set with the values transformed to uppercase @sqlfn upper() More...
 
Datum Timestamptz_shift (PG_FUNCTION_ARGS)
 Return a timestamptz shifted by an interval @sqlfn shift() More...
 
Datum Tstzset_scale (PG_FUNCTION_ARGS)
 Return a timestamptz set scaled by an interval @sqlfn scale() More...
 
Datum Tstzset_shift (PG_FUNCTION_ARGS)
 Return a timestamptz set shifted by an interval @sqlfn shift() More...
 
Datum Tstzset_shift_scale (PG_FUNCTION_ARGS)
 Return a timestamptz set shifted and scaled by two intervals @sqlfn shiftScale() More...
 
Datum Tstzspan_scale (PG_FUNCTION_ARGS)
 Return a timestamptz span scaled by an interval @sqlfn scale() More...
 
Datum Tstzspan_shift (PG_FUNCTION_ARGS)
 Return a timestamptz span shifted by an interval @sqlfn shift() More...
 
Datum Tstzspan_shift_scale (PG_FUNCTION_ARGS)
 Return a timestamptz span shifted and scaled by two intervals @sqlfn shiftScale() 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...
 

Detailed Description

Transformation functions for set and span types.