Appendix A. MobilityDB Reference

Table of Contents

Functions and Operators for Time Types and Range Types
Constructor Functions
Casting
Accessor Functions
Modification Functions
Comparison Operators
Set Operators
Topological and Relative Position Operators
Aggregate Functions
Functions and Operators for Box Types
Constructor Functions
Casting
Accessor Functions
Modification Functions
Spatial Reference System Functions
Aggregate Functions
Comparison Operators
Set Operators
Topological Operators
Relative Position Operators
Functions and Operators for Temporal Types
Constructor Functions
Casting
Accessor Functions
Modification Functions
Restriction Functions
Comparison Operators
Mathematical Functions and Operators
Boolean Operators
Text Functions and Operators
Spatial Functions and Operators
Multidimensional Tiling
Aggregate Functions
Utility Functions
Functions and Operators for Temporal Network Points
Static Network Types
Temporal Network Points

Functions and Operators for Time Types and Range Types

Constructor Functions

Casting

Accessor Functions

Modification Functions

  • shift: Shift the time value by an interval

  • setPrecision: Round the bounds of a float range to a number of decimal places

Comparison Operators

  • =: Are the time values equal?

  • <>: Are the time values different?

  • <: Is the first time value less than the second one?

  • >: Is the first time value greater than the second one?

  • <=: Is the first time value less than or equal to the second one?

  • >=: Is the first time value greater than or equal to the second one?

Set Operators

  • +: Union of the time values

  • *: Intersection of the time values

  • -: Difference of the time values

Topological and Relative Position Operators

  • &&: Do the time values overlap (have instants in common)?

  • @>: Does the first time value contain the second one?

  • <@: Is the first time value contained by the second one?

  • -|-: Is the first time value adjacent to the second one?

  • <<: Is the first number or range value scritly left of the second one?

  • >>: Is the first number or range value strictly right of the second one?

  • &<: Is the first number or range value not to the right of the second one?

  • &>: Is the first number or range value not to the left of the second one?

  • -|-: Is the first number or range value adjacent to the second one?

  • <<#: Is the first time value scritly before the second one?

  • #>>: Is the first time value strictly after the second one?

  • &<#: Is the first time value not after the second one?

  • #&>: Is the first time value not before the second one?

Aggregate Functions