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
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
, tnumber::{numspan,tbox}
, tpoint::stbox
: Convert a temporal value to a bounding box
tint::tfloat
, tfloat::tint
: Convert between a temporal integer and a temporal float
tgeompoint::tgeogpoint
, tgeogpoint::tgeompoint
: Convert between a temporal geometry point and a temporal geography point
tgeompoint::geometry, tgeogpoint::geography
, geometry::tgeompoint, geography::tgeogpoint
: Convert between a temporal point and a PostGIS trajectory
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
valueSpan
, timeSpan
: Return the value or time span
valueSet
: Return the values of the temporal number as a set
startValue
, endValue
, valueN
: Return the start, end, or n-th value
minValue
, maxValue
: Return the minimum or maximum value
minInstant
, maxInstant
: Return the instant with the minimum or maximum value
valueAtTimestamp
: Return the value at a timestamp
duration
: Return the duration
lowerInc
, upperInc
: Is the start/end instant inclusive?
numInstants
: Return the number of different instants
startInstant
, endInstant
, instantN
: Return the start, end, or n-th instant
instants
: Return the different instants
numTimestamps
: Return the number of different timestamps
startTimestamp
, endTimestamp
, timestampN
: Return the start, end, or n-th timestamp
timestamps
: Return the different timestamps
numSequences
: Return the number of sequences
startSequence
, endSequence
, sequenceN
: Return the start, end, or n-th sequence
sequences
: Return the sequences
segments
: Return the segments
integral
: Return the area under the curve
twAvg
: Return the time-weighted average
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
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
atMin
, minusMin
: Restrict to (the complement of) the minimum value
atMax
, minusMax
: Restrict to (the complement of) the maximum value
atGeometry
, minusGeometry
: Restrict to (the complement of) a geometry, a Z span, and/or a period
atTime
, minusTime
: Restrict to (the complement of) a time value
atTbox
, minusTbox
: Restrict to (the complement of) a tbox
atStbox
, minusStbox
: Restrict to (the complement of) an stbox
=
: 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?
?=
, %=
: 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?