asText
: Return the Well-Known Text (WKT) representation
asMFJSON
: Return the Moving Features JSON (MF-JSON) representation
asBinary
, asHexWKB
: Return the Well-Known Binary (WKB) or the Hexadecimal Well-Known Binary (HexWKB) representation
ttypeFromMFJSON
: Input from a Moving Features JSON (MF-JSON) representation
ttypeFromBinary
, ttypeFromHexWKB
: Input from the Well-Known Binary (WKB) or from the Hexadecimal Well-Known Binary (HexWKB) representation
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
ttype::tstzspan
: Convert a temporal value to a timestamptz span
memSize
: Return the memory size in bytes
tempSubtype
: Return the temporal subtype
interp
: Return the interpolation
getValue
, getTimestamp
: Return the value or the timestamp of an instant
getValues
, getTime
: Return the values or the time on which the temporal value is defined
startValue
, endValue
, valueN
: Return the start, end, or n-th value
valueAtTimestamp
: Return the value at a timestamp
duration
: Return the duration
lowerInc
, upperInc
: Is the start/end instant inclusive?
numInstants
, instants
: Return the (number of) different instants
startInstant
, endInstant
, instantN
: Return the start, end, or n-th instant
numTimestamps
, timestamps
: Return the (number of different) timestamps
startTimestamp
, endTimestamp
, timestampN
: Return the start, end, or n-th timestamp
numSequences
, sequences
: Return the (number of) sequences
startSequence
, endSequence
, sequenceN
: Return the start, end, or n-th sequence
segments
: Return the segments
ttypeInst, ttypeSeq, ttypeSeqSet
: Transform a temporal value to another subtype
setInterp
: Transform a temporal value to another interpolation
shiftTime
, scaleTime
, shiftScaleTime
: Shift and/or scale the time span of a temporal value by one or two interval
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
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
atValues
, minusValues
: Restrict to (the complement of) a set of values
atTime
, minusTime
: Restrict to (the complement of) a time value
=
, <>
, <
, >
, <=
, >=
: Traditional comparisons
?=
, %=
, ?<>
, %<>
, ?<
, %<
, ?>
, %>
, ?<=
, %<=
, ?>=
, %>=
: Ever and always comparisons
#=
, #<>
, #<
, #>
, #<=
, #>=
: Temporal comparisons
mobilitydb_version
: Return the version of the MobilityDB extension
mobilitydb_full_version
: Return the versions of the MobilityDB extension and its dependencies