MobilityDB 1.1
Functions

Accessor functions for temporal types. More...

Collaboration diagram for Accessor functions:

Functions

PGDLLEXPORT Datum Mobilitydb_full_version (PG_FUNCTION_ARGS)
 Versions of the MobilityDB extension and its dependencies. More...
 
PGDLLEXPORT Datum Mobilitydb_version (PG_FUNCTION_ARGS)
 Version of the MobilityDB extension. More...
 
PGDLLEXPORT Datum Npoint_position (PG_FUNCTION_ARGS)
 Return the position of the network point. More...
 
PGDLLEXPORT Datum Npoint_route (PG_FUNCTION_ARGS)
 Return the route of the network point. More...
 
PGDLLEXPORT Datum Nsegment_end_position (PG_FUNCTION_ARGS)
 Return the end position of the network segment. More...
 
PGDLLEXPORT Datum Nsegment_route (PG_FUNCTION_ARGS)
 Return the route of the network segment. More...
 
PGDLLEXPORT Datum Nsegment_start_position (PG_FUNCTION_ARGS)
 Return the start position of the network segment. More...
 
PGDLLEXPORT Datum Temporal_duration (PG_FUNCTION_ARGS)
 Return the duration of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_end_instant (PG_FUNCTION_ARGS)
 Return the end instant of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_end_sequence (PG_FUNCTION_ARGS)
 Return the end sequence of a temporal sequence (set) More...
 
PGDLLEXPORT Datum Temporal_end_timestamp (PG_FUNCTION_ARGS)
 Return the end timestamp of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_end_value (PG_FUNCTION_ARGS)
 Return the end base value of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_hash (PG_FUNCTION_ARGS)
 Return the hash value of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_instant_n (PG_FUNCTION_ARGS)
 Return the n-th instant of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_instants (PG_FUNCTION_ARGS)
 Return the distinct instants of a temporal value as an array. More...
 
PGDLLEXPORT Datum Temporal_interpolation (PG_FUNCTION_ARGS)
 Return the string representation of the interpolation of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_max_instant (PG_FUNCTION_ARGS)
 Return a pointer to the instant with maximum base value of the temporal value. More...
 
PGDLLEXPORT Datum Temporal_max_value (PG_FUNCTION_ARGS)
 Return the maximum base value of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_mem_size (PG_FUNCTION_ARGS)
 Return the memory size in bytes of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_min_instant (PG_FUNCTION_ARGS)
 Return a pointer to the instant with the minimum base value of the temporal value. More...
 
PGDLLEXPORT Datum Temporal_min_value (PG_FUNCTION_ARGS)
 Return the minimum base value of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_num_instants (PG_FUNCTION_ARGS)
 Return the number of distinct instants of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_num_sequences (PG_FUNCTION_ARGS)
 Return the number of sequences of a temporal sequence (set) More...
 
PGDLLEXPORT Datum Temporal_num_timestamps (PG_FUNCTION_ARGS)
 Return the number of distinct timestamps of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_segments (PG_FUNCTION_ARGS)
 Return the segments of a temporal sequence (set) as an array. More...
 
PGDLLEXPORT Datum Temporal_sequence_n (PG_FUNCTION_ARGS)
 Return the n-th sequence of a temporal sequence (set) More...
 
PGDLLEXPORT Datum Temporal_sequences (PG_FUNCTION_ARGS)
 Return the sequences of a temporal sequence (set) as an array. More...
 
PGDLLEXPORT Datum Temporal_start_instant (PG_FUNCTION_ARGS)
 Return the start instant of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_start_sequence (PG_FUNCTION_ARGS)
 Return the start sequence of a temporal sequence (set) More...
 
PGDLLEXPORT Datum Temporal_start_timestamp (PG_FUNCTION_ARGS)
 Return the start timestamp of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_start_value (PG_FUNCTION_ARGS)
 Return the start base value of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_subtype (PG_FUNCTION_ARGS)
 Return the string representation of the subtype of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_time (PG_FUNCTION_ARGS)
 Return the time on which a temporal value is defined as a period set. More...
 
PGDLLEXPORT Datum Temporal_timestamp_n (PG_FUNCTION_ARGS)
 Return the n-th distinct timestamp of a temporal value. More...
 
PGDLLEXPORT Datum Temporal_timestamps (PG_FUNCTION_ARGS)
 Return the distinct timestamps of a temporal value as an array. More...
 
PGDLLEXPORT Datum Temporal_value_at_timestamp (PG_FUNCTION_ARGS)
 Return the base value of a temporal value at the timestamp. More...
 
PGDLLEXPORT Datum Temporal_values (PG_FUNCTION_ARGS)
 Return the base values of a temporal value as an array. More...
 
PGDLLEXPORT Datum Tfloat_spanset (PG_FUNCTION_ARGS)
 Return the base values of a temporal float as an array of spans. More...
 
PGDLLEXPORT Datum Tinstant_get_value (PG_FUNCTION_ARGS)
 Return the base value of a temporal instant. More...
 
PGDLLEXPORT Datum Tinstant_timestamp (PG_FUNCTION_ARGS)
 Return the timestamp of a temporal instant. More...
 
PGDLLEXPORT Datum Tnpoint_positions (PG_FUNCTION_ARGS)
 Return the network segments covered by the temporal network point. More...
 
PGDLLEXPORT Datum Tnpoint_route (PG_FUNCTION_ARGS)
 Return the route of a temporal network point. More...
 
PGDLLEXPORT Datum Tnpoint_routes (PG_FUNCTION_ARGS)
 Return the array of routes of a temporal network point. More...
 
PGDLLEXPORT Datum Tpoint_traversed_values (PG_FUNCTION_ARGS)
 Return the base values (that is, the trajectory) of a temporal point value as a geometry/geography. More...
 

Detailed Description

Accessor functions for temporal types.