asText: Return the Well-Known Text (WKT) representationasMFJSON: Return the Moving Features JSON (MF-JSON) representationasBinary,asHexWKB: Return the Well-Known Binary (WKB) or the Hexadecimal Well-Known Binary (HexWKB) representationttypeFromMFJSON: Input from the Moving Features JSON (MF-JSON) representationttypeFromBinary,ttypeFromHexWKB: Input from the Well-Known Binary (WKB) or from the Hexadecimal Well-Known Binary (HexWKB) representation
ttype: Constructors for temporal types having a constant valuettypeSeq: Constructors for temporal types of sequence subtypettypeSeqSet,ttypeSeqSetGaps: Constructors for temporal types of sequence set subtype
::: Convert a temporal value to a timestamptz span
memSize: Return the memory size in bytestempSubtype: Return the temporal typetempBasetype: Return the base typeinterp: Return the interpolationgetValue,getTimestamp: Return the value or the timestamp of an instantgetValues,getTime: Return the values or the time on which a temporal value is definedtimeSpan: Return the bounding period on which a temporal value is definedstartValue,endValue,valueN: Return the start, end, or n-th valuevalueAtTimestamp: Return the value at a timestampduration: Return the time intervallowerInc,upperInc: Is the start/end instant inclusive?numInstants,instants: Return the (number of) different instantsstartInstant,endInstant,instantN: Return the start, end, or n-th instantnumTimestamps,timestamps: Return the (number of) different timestampsstartTimestamp,endTimestamp,timestampN: Return the start, end, or n-th timestampnumSequences,sequences: Return the (number of) sequencesstartSequence,endSequence,sequenceN: Return the start, end, or n-th sequencesegments: Return the segments
ttypeInst,ttypeSeq,ttypeSeqSet: Transform a temporal value to another subtypesetInterp: Transform a temporal value to another interpolationsegmentMinDuration,segmentMaxDuration: Return a temporal boolean stating whether each segment of a continuous temporal sequence (set) has, respectively, at least or at most a given durationshiftTime,scaleTime,shiftScaleTime: Shift and/or scale the time span of a temporal value by one or two intervalsunnest: Transform a nonlinear temporal value into a set of rows, each one is a pair composed of a base value and a period set during which the temporal value has the base value
insert: Insert a temporal value into another oneupdate: Update a temporal value with another onedeleteTime: Delete the instants of a temporal value that intersect a time valueappendInstant,appendInstantAgg: Append a temporal instant to a temporal valueappendSequence,appendSequenceAgg: Append a temporal sequence to a temporal valuemerge,mergeAgg: Merge the temporal values
atValue,minusValue,atValues,minusValues,atSpan,minusSpan,atSpanset,minusSpanset: Restrict to (the complement of) a value or a set of values, or, for a temporal number, a span or a span set of valuesatTime,minusTime: Restrict to (the complement of) a time valuebeforeTimestamp,afterTimestamp: Keep the instants of a temporal value that are before/after or equal a timestamp
=,<>,<,>,<=,>=,cmp: Traditional comparisons
?=,?<>,?<,?>,?<=,?>=,%=,%<>,%<,%>,%<=,%>=: Ever and always comparisons
#=,#<>,#<,#>,#<=,#>=: Temporal comparisons
mobilitydbVersion: Version of the MobilityDB extensionmobilitydbFullVersion: Versions of the MobilityDB extension and its dependencies