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

Accessor functions for temporal types. More...

Functions

bool tbool_end_value (const Temporal *temp)
 Return the end value of a temporal boolean. More...
 
bool tbool_start_value (const Temporal *temp)
 Return the start value of a temporal boolean. More...
 
bool tbool_value_at_timestamptz (const Temporal *temp, TimestampTz t, bool strict, bool *value)
 Return the value of a temporal boolean at a timestamptz. More...
 
bool tbool_value_n (const Temporal *temp, int n, bool *result)
 Return the n-th value of a temporal boolean. More...
 
booltbool_values (const Temporal *temp, int *count)
 Return the array of base values of a temporal boolean. More...
 
Intervaltemporal_duration (const Temporal *temp, bool boundspan)
 Return the duration of a temporal value. More...
 
TInstanttemporal_end_instant (const Temporal *temp)
 Return a copy of the end instant of a temporal value. More...
 
TSequencetemporal_end_sequence (const Temporal *temp)
 Return a copy of the end sequence of a temporal sequence (set) More...
 
TimestampTz temporal_end_timestamptz (const Temporal *temp)
 Return the end timestamptz of a temporal value. More...
 
uint32 temporal_hash (const Temporal *temp)
 Return the 32-bit hash value of a temporal value. More...
 
TInstanttemporal_instant_n (const Temporal *temp, int n)
 Return a copy of the n-th instant of a temporal value. More...
 
TInstant ** temporal_instants (const Temporal *temp, int *count)
 Return a copy of the distinct instants of a temporal value. More...
 
const char * temporal_interp (const Temporal *temp)
 Return the string representation of the interpolation of a temporal value. More...
 
bool temporal_lower_inc (const Temporal *temp)
 Return true if the start instant of a temporal value is inclusive. More...
 
TInstanttemporal_max_instant (const Temporal *temp)
 Return a copy of the instant with maximum base value of a temporal value. More...
 
TInstanttemporal_min_instant (const Temporal *temp)
 Return a copy of the instant with minimum base value of a temporal value. More...
 
int temporal_num_instants (const Temporal *temp)
 Return the number of distinct instants of a temporal value. More...
 
int temporal_num_sequences (const Temporal *temp)
 Return the number of sequences of a temporal sequence (set) More...
 
int temporal_num_timestamps (const Temporal *temp)
 Return the number of distinct timestamps of a temporal value. More...
 
TSequence ** temporal_segments (const Temporal *temp, int *count)
 Return the array of segments of a temporal value. More...
 
TSequencetemporal_sequence_n (const Temporal *temp, int n)
 Return a copy of the n-th sequence of a temporal sequence (set) More...
 
TSequence ** temporal_sequences (const Temporal *temp, int *count)
 Return an array of copies of the sequences of a temporal sequence (set) More...
 
TInstanttemporal_start_instant (const Temporal *temp)
 Return a copy of the start instant of a temporal value. More...
 
TSequencetemporal_start_sequence (const Temporal *temp)
 Return a copy of the start sequence of a temporal sequence (set) More...
 
TimestampTz temporal_start_timestamptz (const Temporal *temp)
 Return the start timestamptz of a temporal value. More...
 
TSequenceSettemporal_stops (const Temporal *temp, double maxdist, const Interval *minduration)
 Return the subsequences where a temporal value stays within a given distance for at least a given duration. More...
 
const char * temporal_subtype (const Temporal *temp)
 Return the string representation of the subtype of a temporal value. More...
 
SpanSettemporal_time (const Temporal *temp)
 Return the time frame of a temporal value as a span set. More...
 
TimestampTztemporal_timestamps (const Temporal *temp, int *count)
 Return the array of distinct timestamps of a temporal value. More...
 
bool temporal_timestamptz_n (const Temporal *temp, int n, TimestampTz *result)
 Return in last argument the n-th distinct timestamptz of a temporal value. More...
 
bool temporal_upper_inc (const Temporal *temp)
 Return true if the end instant of a temporal value is inclusive. More...
 
double tfloat_end_value (const Temporal *temp)
 Return the end value of a temporal float. More...
 
double tfloat_max_value (const Temporal *temp)
 Return the maximum value of a temporal float. More...
 
double tfloat_min_value (const Temporal *temp)
 Return the minimum value of a temporal float. More...
 
double tfloat_start_value (const Temporal *temp)
 Return the start value of a temporal float. More...
 
bool tfloat_value_at_timestamptz (const Temporal *temp, TimestampTz t, bool strict, double *value)
 Return the value of a temporal integer at a timestamptz. More...
 
bool tfloat_value_n (const Temporal *temp, int n, double *result)
 Return the n-th value of a temporal float. More...
 
double * tfloat_values (const Temporal *temp, int *count)
 Return the array of base values of a temporal float. More...
 
int tint_end_value (const Temporal *temp)
 Return the end value of a temporal integer. More...
 
int tint_max_value (const Temporal *temp)
 Return the maximum value of a temporal integer. More...
 
int tint_min_value (const Temporal *temp)
 Return the minimum value of a temporal integer. More...
 
int tint_start_value (const Temporal *temp)
 Return the start value of a temporal integer. More...
 
bool tint_value_at_timestamptz (const Temporal *temp, TimestampTz t, bool strict, int *value)
 Return the value of a temporal integer at a timestamptz. More...
 
bool tint_value_n (const Temporal *temp, int n, int *result)
 Return the n-th value of a temporal integer. More...
 
int * tint_values (const Temporal *temp, int *count)
 Return the array of base values of a temporal integer. More...
 
double tnumber_integral (const Temporal *temp)
 Return the integral (area under the curve) of a temporal number. More...
 
double tnumber_twavg (const Temporal *temp)
 Return the time-weighted average of a temporal number. More...
 
SpanSettnumber_valuespans (const Temporal *temp)
 Return the base values of a temporal number as a span set. More...
 
textttext_end_value (const Temporal *temp)
 Return a copy of the end value of a temporal text. More...
 
textttext_max_value (const Temporal *temp)
 Return a copy of the maximum value of a temporal text. More...
 
textttext_min_value (const Temporal *temp)
 Return a copy of the minimum value of a temporal text. More...
 
textttext_start_value (const Temporal *temp)
 Return a copy of the start value of a temporal text. More...
 
bool ttext_value_at_timestamptz (const Temporal *temp, TimestampTz t, bool strict, text **value)
 Return the value of a temporal integer at a timestamptz. More...
 
bool ttext_value_n (const Temporal *temp, int n, text **result)
 Return a copy of the n-th value of a temporal text. More...
 
text ** ttext_values (const Temporal *temp, int *count)
 Return the array of copies of base values of a temporal text. More...
 

Detailed Description

Accessor functions for temporal types.