 |
MobilityDB 1.3
|
Loading...
Searching...
No Matches
|
MobilityDB 1.3
|
General functions for set types composed of an ordered list of distinct values. More...
#include "temporal/set.h"#include <postgres.h>#include <access/heaptoast.h>#include <access/detoast.h>#include <funcapi.h>#include <utils/timestamp.h>#include <meos.h>#include <meos_internal.h>#include "temporal/span.h"#include "temporal/temporal.h"#include "temporal/type_inout.h"#include "temporal/type_util.h"#include "pg_temporal/meos_catalog.h"#include "pg_temporal/temporal.h"#include "pg_temporal/type_util.h"Functions | |
| Datum | Dateset_to_tstzset (PG_FUNCTION_ARGS) |
| Convert a date set into a timestamptz set @sqlfn tstzset() More... | |
| Datum | Dateset_to_tstzsset (PG_FUNCTION_ARGS) |
| 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 | Floatset_to_intset (PG_FUNCTION_ARGS) |
| Convert a float set into a integer set @sqlfn intset() More... | |
| Datum | Intset_to_floatset (PG_FUNCTION_ARGS) |
| Convert an integer set into a float set @sqlfn floatset() 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 | Set_as_hexwkb (PG_FUNCTION_ARGS) |
| Return the ASCII hex-encoded Well-Known Binary (HexWKB) representation of a set @sqlfn asHexWKB() More... | |
| Datum | Set_as_text (PG_FUNCTION_ARGS) |
| Return the Well-Known Text (WKT) representation of a set @sqlfn asText() More... | |
| Datum | Set_as_wkb (PG_FUNCTION_ARGS) |
| Return the Well-Known Binary (WKB) representation of a set @sqlfn asBinary() More... | |
| Datum | Set_cmp (PG_FUNCTION_ARGS) |
| Return -1, 0, or 1 depending on whether the first set is less than, equal to, or greater than the second one @sqlfn set_cmp() More... | |
| Datum | Set_constructor (PG_FUNCTION_ARGS) |
| Return a set from an array of values @sqlfn set() More... | |
| Datum | Set_end_value (PG_FUNCTION_ARGS) |
| Return the end value of a set @sqlfn endValue() More... | |
| Datum | Set_eq (PG_FUNCTION_ARGS) |
| Return true if the first set is equal to the second one @sqlfn set_eq() More... | |
| Datum | Set_from_hexwkb (PG_FUNCTION_ARGS) |
| Return a set from its ASCII hex-encoded Well-Known Binary (HexWKB) representation @sqlfn intsetFromHexWKB(), floatsetFromHexWKB(), ... More... | |
| Datum | Set_from_wkb (PG_FUNCTION_ARGS) |
| Return a set from its Well-Known Binary (WKB) representation @sqlfn intsetFromBinary(), floatsetFromWKB(), ... More... | |
| Datum | Set_ge (PG_FUNCTION_ARGS) |
| Return true if the first set is greater than or equal to the second one @sqlfn set_ge() More... | |
| Datum | Set_gt (PG_FUNCTION_ARGS) |
| Return true if the first set is greater than the second one @sqlfn set_gt() More... | |
| Datum | Set_hash (PG_FUNCTION_ARGS) |
| Return the 32-bit hash value of a set @sqlfn hash() More... | |
| Datum | Set_hash_extended (PG_FUNCTION_ARGS) |
| Return the 64-bit hash value of a set using a seed @sqlfn hash_extended() More... | |
| Datum | Set_in (PG_FUNCTION_ARGS) |
| Return a set from its Well-Known Text (WKT) representation @sqlfn intset_in(), floatset_in(), ... More... | |
| Datum | Set_le (PG_FUNCTION_ARGS) |
| Return true if the first set is less than or equal to the second one @sqlfn set_le() More... | |
| Datum | Set_lt (PG_FUNCTION_ARGS) |
| Return true if the first set is less than the second one @sqlfn set_lt() More... | |
| Datum | Set_mem_size (PG_FUNCTION_ARGS) |
| Return the memory size in bytes of a set @sqlfn memSize() More... | |
| Datum | Set_ne (PG_FUNCTION_ARGS) |
| Return true if the first set is different from the second one @sqlfn set_ne() More... | |
| Datum | Set_num_values (PG_FUNCTION_ARGS) |
| Return the number of values of a set @sqlfn numValues() More... | |
| Datum | Set_out (PG_FUNCTION_ARGS) |
| Return the Well-Known Text (WKT) representation of a set @sqlfn intset_out(), floatset_out(), ... More... | |
| Datum | Set_recv (PG_FUNCTION_ARGS) |
| Return a set from its Well-Known Binary (WKB) representation @sqlfn intset_recv(), floatset_recv(), ... 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_send (PG_FUNCTION_ARGS) |
| Return the Well-Known Binary (WKB) representation of a set @sqlfn intset_send(), floatset_send(), ... More... | |
| Datum | Set_start_value (PG_FUNCTION_ARGS) |
| Return the start value of a set @sqlfn startValue() More... | |
| Datum | Set_unnest (PG_FUNCTION_ARGS) |
| Return the list of values of a set. More... | |
| Datum | Set_value_n (PG_FUNCTION_ARGS) |
| Return the n-th value of a set @sqlfn valueN() More... | |
| Datum | Set_values (PG_FUNCTION_ARGS) |
| Return the array of values of a set @sqlfn getValues() 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 | 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 | Tstzset_to_dateset (PG_FUNCTION_ARGS) |
| Convert a timestamptz set into a date set @sqlfn dateset() More... | |
| Datum | Value_to_set (PG_FUNCTION_ARGS) |
| Convert a base value into a set @sqlfn set() More... | |
General functions for set types composed of an ordered list of distinct values.
1.9.5