 |
MobilityDB 1.3
|
|
MobilityDB 1.3
|
Accessor functions for temporal types. More...
Functions | |
| Datum | Temporal_duration (PG_FUNCTION_ARGS) |
| Return the duration of a temporal value @sqlfn duration() More... | |
| Datum | Temporal_end_instant (PG_FUNCTION_ARGS) |
| Return the end instant of a temporal value @sqlfn endInstant() More... | |
| Datum | Temporal_end_sequence (PG_FUNCTION_ARGS) |
| Return the end sequence of a temporal sequence (set) @sqlfn endSequence() More... | |
| Datum | Temporal_end_timestamptz (PG_FUNCTION_ARGS) |
| Return the end timestamptz of a temporal value @sqlfn endTimestamp() More... | |
| Datum | Temporal_end_value (PG_FUNCTION_ARGS) |
| Return the end base value of a temporal value @sqlfn endValue() More... | |
| Datum | Temporal_hash (PG_FUNCTION_ARGS) |
| Return the hash value of a temporal value @sqlfn tint_hash(), tfloat_hash(), ... More... | |
| Datum | Temporal_instant_n (PG_FUNCTION_ARGS) |
| Return the n-th instant of a temporal value @sqlfn instantN() More... | |
| Datum | Temporal_instants (PG_FUNCTION_ARGS) |
| Return the array of distinct instants of a temporal value @sqlfn instants() More... | |
| Datum | Temporal_interp (PG_FUNCTION_ARGS) |
| Return the interpolation of a temporal value as a string @sqlfn interp() More... | |
| Datum | Temporal_lower_inc (PG_FUNCTION_ARGS) |
| Return true if the start instant of a temporal value is inclusive @sqlfn lowerInc() More... | |
| Datum | Temporal_max_instant (PG_FUNCTION_ARGS) |
| Return the instant with maximum base value of a temporal value @sqlfn maxInstant() More... | |
| Datum | Temporal_max_value (PG_FUNCTION_ARGS) |
| Return the maximum base value of a temporal value @sqlfn maxValue() More... | |
| Datum | Temporal_mem_size (PG_FUNCTION_ARGS) |
| Return the memory size in bytes of a temporal value @sqlfn memSize() More... | |
| Datum | Temporal_min_instant (PG_FUNCTION_ARGS) |
| Return the instant with the minimum base value of a temporal value @sqlfn minInstant() More... | |
| Datum | Temporal_min_value (PG_FUNCTION_ARGS) |
| Return the minimum base value of a temporal value @sqlfn minValue() More... | |
| Datum | Temporal_num_instants (PG_FUNCTION_ARGS) |
| Return the number of distinct instants of a temporal value @sqlfn numInstants() More... | |
| Datum | Temporal_num_sequences (PG_FUNCTION_ARGS) |
| Return the number of sequences of a temporal sequence (set) @sqlfn numSequences() More... | |
| Datum | Temporal_num_timestamps (PG_FUNCTION_ARGS) |
| Return the number of distinct timestamps of a temporal value @sqlfn numTimestamps() More... | |
| Datum | Temporal_segments (PG_FUNCTION_ARGS) |
| Return the array of segments of a temporal sequence (set) @sqlfn segments() More... | |
| Datum | Temporal_sequence_n (PG_FUNCTION_ARGS) |
| Return the n-th sequence of a temporal sequence (set) @sqlfn sequenceN() More... | |
| Datum | Temporal_sequences (PG_FUNCTION_ARGS) |
| Return the array of sequences of a temporal sequence (set) @sqlfn sequences() More... | |
| Datum | Temporal_start_instant (PG_FUNCTION_ARGS) |
| Return the start instant of a temporal value @sqlfn startInstant() More... | |
| Datum | Temporal_start_sequence (PG_FUNCTION_ARGS) |
| Return the start sequence of a temporal sequence (set) @sqlfn startSequence() More... | |
| Datum | Temporal_start_timestamptz (PG_FUNCTION_ARGS) |
| Return the start timestamptz of a temporal value @sqlfn startTimestamp() More... | |
| Datum | Temporal_start_value (PG_FUNCTION_ARGS) |
| Return the start base value of a temporal value @sqlfn startValue() More... | |
| Datum | Temporal_stops (PG_FUNCTION_ARGS) |
| Return the constant segments of a temporal value @sqlfn stops() More... | |
| Datum | Temporal_subtype (PG_FUNCTION_ARGS) |
| Return the subtype of a temporal value as a string @sqlfn tempSubtype() More... | |
| Datum | Temporal_time (PG_FUNCTION_ARGS) |
| Return the time on which a temporal value is defined as a span set @sqlfn getTime() More... | |
| Datum | Temporal_timestamps (PG_FUNCTION_ARGS) |
| Return the array of distinct timestamps of a temporal value @sqlfn timestamps() More... | |
| Datum | Temporal_timestamptz_n (PG_FUNCTION_ARGS) |
| Return the n-th distinct timestamptz of a temporal value @sqlfn timestampN() More... | |
| Datum | Temporal_upper_inc (PG_FUNCTION_ARGS) |
| Return true if the end instant of a temporal value is inclusive @sqlfn upperInc() More... | |
| Datum | Temporal_value_at_timestamptz (PG_FUNCTION_ARGS) |
| Return the base value of a temporal value at a timestamptz @sqlfn valueAtTimestamp() More... | |
| Datum | Temporal_value_n (PG_FUNCTION_ARGS) |
| Return the n-th value of a temporal value @sqlfn valueN() More... | |
| Datum | Temporal_valueset (PG_FUNCTION_ARGS) |
| Return the base values of a temporal value as a set @sqlfn getValues() More... | |
| Datum | Tinstant_timestamptz (PG_FUNCTION_ARGS) |
| Return the timestamptz of a temporal instant @sqlfn getTimestamp() More... | |
| Datum | Tinstant_value (PG_FUNCTION_ARGS) |
| Return the base value of a temporal instant @sqlfn getValue() More... | |
| Datum | Tnumber_integral (PG_FUNCTION_ARGS) |
| Return the integral (area under the curve) of a temporal number @sqlfn integral() More... | |
| Datum | Tnumber_valuespans (PG_FUNCTION_ARGS) |
| Return the value span set of a temporal number @sqlfn getValues() More... | |
Accessor functions for temporal types.
1.9.5