Operations for Temporal Types: Generic Operations

Input and Output

  • asText: Return the Well-Known Text (WKT) representation

  • asBinary: Return the Well-Known Binary (WKB) representation

  • asHexWKB: Return the Hexadecimal Well-Known Binary (HexWKB) representation as text

  • asMFJSON: Return the Moving Features JSON (MF-JSON) representation

  • ttypeFromBinary: Input from a Well-Known Binary (WKB) representation

  • ttypeFromHexWKB: Input from an Hexadecimal Well-Known Binary (HexWKB) representation

  • ttypeFromMFJSON: Input from a Moving Features JSON (MF-JSON) representation

Constructors

  • ttype: Constructor for temporal types from a base value and a time value

  • ttypeSeq: Constructor for temporal types of sequence subtype

  • ttypeSeqSet, ttypeSeqSetGaps: Constructor for temporal types of sequence set subtype

Conversions

Accessors

Transformations

  • ttypeInst, ttypeSeq, ttypeSeqSet: Transform a temporal value to another subtype

  • setInterp: Transform a temporal value to another interpolation

  • shiftValue, shiftTime: Shift the value or time span of the temporal value by a value or interval

  • scaleValue, scaleTime: Scale the value or time span of the temporal value to a value or interval

  • shiftScaleValue, shiftScaleTime: Shift and scale the value or time span the temporal value with the values or intervals

  • stops: Extract from a temporal sequence (set) with linear interpolation the subsequences where the objects stays within an area with a given maximum size for at least the specified duration.

  • unnest: Transform a nonlinear temporal value into a set of rows, each one containing a base value and a period set during which the temporal value has the base value

Modifications

  • insert: Insert a temporal value into another one

  • update: Update a temporal value with another one

  • deleteTime: Delete the instants of a temporal value that intersect a time value

  • appendInstant: Append a temporal instant to a temporal value

  • appendSequence: Append a temporal sequence to a temporal value

  • merge: Merge temporal values

Restrictions

Comparisons

Traditional Comparisons

  • =: Are the temporal values equal?

  • <>: Are the temporal values different?

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

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

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

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

Ever and Always Comparisons

  • ?=, %=: Is the temporal value ever or always equal to the value?

  • ?<>, %<>: Is the temporal value ever or always different from the value?

  • ?<, %<: Is the temporal value ever or always less than the value?

  • ?>, %>: Is the temporal value ever or always greater than the value?

  • ?<=, %<=: Is the temporal value ever or always less than or equal to the value?

  • ?>=, %>=: Is the temporal value ever or always greater than or equal to the value?

Temporal Comparisons

  • #=: Temporal equal

  • #<>: Temporal different

  • #<: Temporal less than

  • #>: Temporal greater than

  • #<=: Temporal less than or equal to

  • #>=: Temporal greater than or equal to