 |
MobilityDB 1.3
|
|
MobilityDB 1.3
|
Transformation functions for set and span types. More...
Functions | |
| Set * | bigintset_shift_scale (const Set *s, int64 shift, int64 width, bool hasshift, bool haswidth) |
| Return a big integer set shifted and/or scaled by two values. More... | |
| Span * | bigintspan_expand (const Span *s, int64 i) |
| Return a big integer span with its bounds expanded/decreased by a value. More... | |
| Span * | bigintspan_shift_scale (const Span *s, int64 shift, int64 width, bool hasshift, bool haswidth) |
| Return a big integer span shifted and/or scaled by the values. More... | |
| SpanSet * | bigintspanset_shift_scale (const SpanSet *ss, int64 shift, int64 width, bool hasshift, bool haswidth) |
| Return a big integer span shifted and/or scaled by two values. More... | |
| Set * | dateset_shift_scale (const Set *s, int shift, int width, bool hasshift, bool haswidth) |
| Return a date set shifted and/or scaled by two values. More... | |
| Span * | datespan_shift_scale (const Span *s, int shift, int width, bool hasshift, bool haswidth) |
| Return a date span shifted and/or scaled by the values. More... | |
| SpanSet * | datespanset_shift_scale (const SpanSet *ss, int shift, int width, bool hasshift, bool haswidth) |
| Return a date span shifted and/or scaled by two values. More... | |
| Set * | floatset_ceil (const Set *s) |
| Return a float set rounded up to the nearest integer @csqlfn Floatset_ceil() More... | |
| Set * | floatset_degrees (const Set *s, bool normalize) |
| Convert a float set with the values into degrees. More... | |
| Set * | floatset_floor (const Set *s) |
| Return a float set rounded down to the nearest integer @csqlfn Floatset_floor() More... | |
| Set * | floatset_radians (const Set *s) |
| Convert a float set with the values into radians. More... | |
| Set * | floatset_shift_scale (const Set *s, double shift, double width, bool hasshift, bool haswidth) |
| Return a float set shifted and/or scaled by two values. More... | |
| Span * | floatspan_ceil (const Span *s) |
| Return a float span rounded up to the nearest integer @csqlfn Floatspan_ceil() More... | |
| Span * | floatspan_degrees (const Span *s, bool normalize) |
| Return a float span with the values converted to degrees. More... | |
| Span * | floatspan_expand (const Span *s, double d) |
| Return a float span with its bounds expanded/decreased by a value. More... | |
| Span * | floatspan_floor (const Span *s) |
| Return a float span rounded down to the nearest integer @csqlfn Floatspan_floor() More... | |
| Span * | floatspan_radians (const Span *s) |
| Return a float span with the values converted to radians. More... | |
| Span * | floatspan_round (const Span *s, int maxdd) |
| Return a float span with the precision of the bounds set to a number of decimal places. More... | |
| Span * | floatspan_shift_scale (const Span *s, double shift, double width, bool hasshift, bool haswidth) |
| Return a float span shifted and/or scaled by the values. More... | |
| SpanSet * | floatspanset_ceil (const SpanSet *ss) |
| Return a float span set rounded up to the nearest integer. More... | |
| SpanSet * | floatspanset_degrees (const SpanSet *ss, bool normalize) |
| Return a float span set with the values converted to degrees. More... | |
| SpanSet * | floatspanset_floor (const SpanSet *ss) |
| Return a float span set rounded down to the nearest integer. More... | |
| SpanSet * | floatspanset_radians (const SpanSet *ss) |
| Return a float span set with the values converted to radians. More... | |
| SpanSet * | floatspanset_round (const SpanSet *ss, int maxdd) |
| Return a float span set with the precision of the spans set to a number of decimal places. More... | |
| SpanSet * | floatspanset_shift_scale (const SpanSet *ss, double shift, double width, bool hasshift, bool haswidth) |
| Return a float span shifted and/or scaled by two values. More... | |
| Set * | intset_shift_scale (const Set *s, int shift, int width, bool hasshift, bool haswidth) |
| Return an integer set shifted and/or scaled by two values. More... | |
| Span * | intspan_expand (const Span *s, int i) |
| Return an integer span with its bounds expanded/decreased by a value. More... | |
| Span * | intspan_shift_scale (const Span *s, int shift, int width, bool hasshift, bool haswidth) |
| Return an integer span shifted and/or scaled by the values. More... | |
| SpanSet * | intspanset_shift_scale (const SpanSet *ss, int shift, int width, bool hasshift, bool haswidth) |
| Return an integer span shifted and/or scaled by two values. More... | |
| Set * | set_round (const Set *s, int maxdd) |
| Return a set with the precision of the values set to a number of decimal places. More... | |
| Set * | textcat_text_textset (const text *txt, const Set *s) |
| Return the concatenation of a text and a text set. More... | |
| Set * | textcat_textset_text (const Set *s, const text *txt) |
| Return the concatenation of a text set and a text. More... | |
| Set * | textset_initcap (const Set *s) |
| Return a text set transformed to initcap. More... | |
| Set * | textset_lower (const Set *s) |
| Return a text set transformed to lowercase. More... | |
| Set * | textset_upper (const Set *s) |
| Return a text set transformed to uppercase. More... | |
| TimestampTz | timestamptz_tprecision (TimestampTz t, const Interval *duration, TimestampTz torigin) |
| Return a timestamptz with the precision set to a time bin. More... | |
| Set * | tstzset_shift_scale (const Set *s, const Interval *shift, const Interval *duration) |
| Return a timestamptz set shifted and/or scaled by two intervals. More... | |
| Set * | tstzset_tprecision (const Set *s, const Interval *duration, TimestampTz torigin) |
| Return a timestamptz set with the precision set to a time bin. More... | |
| Span * | tstzspan_expand (const Span *s, const Interval *interv) |
| Return a timestamptz span with its bounds expanded/decreased by an interval. More... | |
| Span * | tstzspan_shift_scale (const Span *s, const Interval *shift, const Interval *duration) |
| Return a timestamptz span shifted and/or scaled by two intervals. More... | |
| Span * | tstzspan_tprecision (const Span *s, const Interval *duration, TimestampTz torigin) |
| Return a timestamptz span with the precision set to a time bin. More... | |
| SpanSet * | tstzspanset_shift_scale (const SpanSet *ss, const Interval *shift, const Interval *duration) |
| Return a timestamptz span set shifted and/or scaled by two intervals. More... | |
| SpanSet * | tstzspanset_tprecision (const SpanSet *ss, const Interval *duration, TimestampTz torigin) |
| Return a timestamptz span set with the precision set to a time bin. More... | |
Transformation functions for set and span types.
1.9.5