Appendix A. MobilityDB Reference

period: Constructor for period

timestampset: Constructor for timestampset

periodset: Constructor for periodset

timestamptz::time: Cast a timestamptz to another time type

timestampset::periodset: Cast a timestampset to a periodset

period::type: Cast a period to another time type

tstzrange::period: Cast a tstzrange to a period

memSize: Get the memory size in bytes

lower: Get the lower bound

upper: Get the upper bound

lower_inc: Is the lower bound inclusive?

upper_inc: Is the upper bound inclusive?

duration: Get the duration

timespan: Get the timespan ignoring the potential time gaps

period: Get the period on which the timestamp set or period set is defined ignoring the potential time gaps

numTimestamps: Get the number of different timestamps

startTimestamp: Get the start timestamp

endTimestamp: Get the end timestamp

timestampN: Get the n-th different timestamp

timestamps: Get the different timestamps

numPeriods: Get the number of periods

startPeriod: Get the start period

endPeriod: Get the end period

periodN: Get the n-th period

periods: Get the periods

shift: Shift the time value by an interval

tscale: Scale the time value to an interval

shiftTscale: Shift and scale the time value with the intervals

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

=: 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?

+: Union of the time values

*: Intersection of the time values

-: Difference of the time values

&&: 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?

<->: Get the smallest distance ever in an interval

|=|: Get the smallest distance ever in number of seconds

tcount: Temporal count

extent: Bounding period

extent: Bounding range

tunion: Temporal union