![]() |
MobilityDB 1.3
|
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... | |
Transformation functions for set and span types.