Appendix A. MobilityDB Reference

Table of Contents

Functions and Operators for Time Types and Range Types
Constructor Functions
Casting
Accessor Functions
Comparison Operators
Set Operators
Topological and Relative Position Operators
Functions and Operators for Box Types
Constructor Functions
Casting
Accessor Functions
Modification Functions
Spatial Reference System Functions
Comparison Operators
Set Operators
Topological Operators
Relative Position Operators
Functions and Operators for Temporal Types
Constructor Functions
Casting
Transformation Functions
Accessor Functions
Spatial Functions
Restriction Functions
Difference Functions
Comparison Operators
Ever and Always Comparison Operators
Temporal Comparison Operators
Mathematical Functions and Operators
Boolean Operators
Text Functions and Operators
Distance Operators
Spatial Relationships for Temporal Points
Aggregate Functions for Temporal Types
Utility Functions

Functions and Operators for Time Types and Range Types

Constructor Functions

Casting

Accessor Functions

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 points 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?