ttype_inst: Constructor for temporal types of instant subtype
ttype_instset: Constructor for temporal types of instant set subtype
ttype_seq: Constructor for temporal types of sequence subtype
ttype_seqset: Constructor for temporal types of sequence set subtype
ttype::period: Cast a temporal value to a period
tnumber::range: Cast a temporal number to a range
tnumber::tbox: Cast a temporal number to a tbox
ttype::period: Cast a temporal point to an stbox
tint::tfloat: Cast a temporal integer to a temporal float
tfloat::tint: Cast a temporal float to a temporal integer
tgeompoint::tgeogpoint: Cast a temporal geometry point to a temporal geography point
tgeogpoint::tgeompoint: Cast a temporal geography point to a temporal geometry point
tgeompoint::geometry, tgeogpoint::geography: Cast a temporal point to a PostGIS trajectory
geometry::tgeompoint, geography::tgeogpoint: Cast a PostGIS trajectory to a temporal point
memSize: Get the memory size in bytes
tempSubtype: Get the temporal subtype
interpolation: Get the interpolation
getValue: Get the value
getValues: Get the values
startValue: Get the start value
endValue: Get the end value
minValue: Get the minimum value
maxValue: Get the maximum value
valueRange: Get the value range
valueAtTimestamp: Get the value at a timestamp
getTimestamp: Get the timestamp
getTime: Get the time
duration: Get the duration
timespan: Get the timespan ignoring the potential time gaps
period: Get the period on which the temporal value is defined ignoring the potential time gaps
numInstants: Get the number of different instants
startInstant: Get the start instant
endInstant: Get the end instant
instantN: Get the n-th different instant
instants: Get the different instants
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
numSequences: Get the number of sequences
startSequence: Get the start sequence
endSequence: Get the end sequence
sequenceN: Get the n-th sequence
sequences: Get the sequences
segments: Get the segments
shift: Shift the time span of the temporal value by an interval
tscale: Scale the time span of the temporal value to an interval
shiftTscale: Shift and scale the time span the temporal value with the intervals
intersectsTimestamp: Does the temporal value intersect the timestamp?
intersectsTimestampSet: Does the temporal value intersect the timestamp set?
intersectsPeriod: Does the temporal value intersect the period?
intersectsPeriodSet: Does the temporal value intersect the period set?
twAvg: Get the time-weighted average
ttype_inst, ttype_instset, ttype_seq, ttype_seqset: Transform a temporal value to another subtype
toLinear: Transform a temporal value with continuous base type from stepwise to linear interpolation
appendInstant: Append a temporal instant to a temporal value
merge: Merge temporal values
atValue: Restrict to a value
atValues: Restrict to an array of values
atRange: Restrict to a range
atRanges: Restrict to an array of ranges
atMin: Restrict to the minimum value
atMax: Restrict to the maximum value
atGeometry: Restrict to a geometry
atTimestamp: Restrict to a timestamp
atTimestampSet: Restrict to a timestamp set
atPeriod: Restrict to a period
atPeriodSet: Restrict to a period set
atTbox: Restrict to a tbox
atStbox: Restrict to an stbox
minusValue: Difference with a value
minusValues: Difference with an array of values
minusRange: Difference with a range
minusRanges: Difference with an array of ranges
minusMin: Difference with the minimum value
minusMax: Difference with the maximum value
minusGeometry: Difference with a geometry
minusTimestamp: Difference with a timestamp
minusTimestampSet: Difference with a timestamp set
minusPeriod: Difference with period
minusPeriodSet: Difference with a period set
minusTbox: Difference with a tbox
minusStbox: Difference with 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 equal to the value?
?<>: Is the temporal value ever different from the value?
?<: Is the temporal value ever less than the value?
?>: Is the temporal value ever greater than the value?
?<=: Is the temporal value ever less than or equal to the value?
?>=: Is the temporal value ever greater than or equal to the value?
%=: Is the temporal value always equal to the value?
%<>: Is the temporal value always different to the value?
%<: Is the temporal value always less than the value?
%>: Is the temporal value always greater than the value?
%<=: Is the temporal value always less than or equal to the value?
%>=: Is the temporal value always greater than or equal to the value?
asText: Get the Well-Known Text (WKT) representation
asEWKT: Get the Extended Well-Known Text (EWKT) representation
asMFJSON: Get the Moving Features JSON representation
asBinary: Get the Well-Known Binary (WKB) representation
asEWKB: Get the Extended Well-Known Binary (EWKB) representation
asHexEWKB: Get the Hexadecimal Extended Well-Known Binary (EWKB) representation as text
tgeompointFromText: Input a temporal geometry point from a Well-Known Text (WKT) representation
tgeogpointFromText: Input a temporal geography point from a Well-Known Text (WKT) representation
tgeompointFromEWKT: Input a temporal geometry point from an Extended Well-Known Text (EWKT) representation
tgeogpointFromEWKT: Input a temporal geography point from an Extended Well-Known Text (EWKT) representation
tgeompointFromMFJSON: Input a temporal geometry point from a Moving Features JSON representation
tgeogpointFromMFJSON: Input a temporal geography geometry point from a Moving Features JSON representation
tgeompointFromBinary: Input a temporal geometry point from a Well-Known Binary (WKB) representation
tgeogpointFromBinary: Input a temporal geography point from a Well-Known Binary (WKB) representation
tgeompointFromEWKB: Input a temporal geometry point from an Extended Well-Known Binary (EWKB) representation
tgeogpointFromEWKB: Input a temporal geography point from an Extended Well-Known Binary (EWKB) representation
tgeompointFromHexEWKB: Input a temporal geometry point from an Hexadecimal Extended Well-Known Binary (EWKB) representation as text
tgeogpointFromHexEWKB: Input a temporal geography point from an Hexadecimal Extended Well-Known Binary (EWKB) representation as text
getX: Get the X coordinate values as a temporal float
getY: Get the Y coordinate values as a temporal float
getZ: Get the Z coordinate values as a temporal float
length: Get the length traversed by the temporal point
isSimple: Returns true if the temporal point does not spatially self-intersect
cumulativeLength: Get the cumulative length traversed by the temporal point
speed: Get the speed of the temporal point in units per second
twCentroid: Get the time-weighted centroid
azimuth: Get the temporal azimuth
bearing: Get the temporal bearing
setPrecision: Round the coordinate values to a number of decimal places
makeSimple: Returns an array of fragments of the temporal point which are simple
simplify: Simplify a temporal point using a generalization of the Douglas-Peucker algorithm
geoMeasure: Construct a geometry/geography with M measure from a temporal point and a temporal float
asMVTGeom: Transform a temporal geometric point into the coordinate space of a Mapbox Vector Tile
|=|: Get the smallest distance ever
nearestApproachInstant: Get the instant of the first temporal point at which the two arguments are at the nearest distance
shortestLine: Get the line connecting the nearest approach point
<->: Get the temporal distance
contains: May contain
disjoint: May be disjoint
dwithin: May be at distance within
intersects: May intersect
touches: May touch
tcontains: Temporal contains
tdisjoint: Temporal disjoint
tdwithin: Temporal distance within
tintersects: Temporal intersects
ttouches: Temporal touches
bucketList: Returns a set of couples (index, bucket) that cover the range or period with buckets of the same width or duration aligned with the origin
valueBucket: Returns the start value of the bucket that contains the input number.
rangeBucket: Returns the range in the bucket space that contains the input number
timeBucket: Returns the start timestamp of the bucket that contains the input timestamp.
periodBucket: Returns a period in the bucket space that contains the input timestamp
multidimGrid: Returns a set of couples (index, tile) that covers the box with multidimensional tiles of the same size and duration.
multidimTile: Returns the tile of the multidimensional grid that contains the value and the timestamp
valueSplit: Fragment the temporal number with respect to value buckets
timeSplit: Fragment the temporal value with respect to time buckets
valueTimeSplit: Fragment the temporal number with respect to the tiles in a value-time grid
spaceSplit: Fragment the temporal point with respect to tiles in a spatial grid
spaceTimeSplit: Fragment the temporal point with respect to tiles in a spatiotemporal grid
tcount: Temporal count
extent: Bounding box extent
tand: Temporal and
tor: Temporal or
tmin: Temporal minimum
tmax: Temporal maximum
tsum: Temporal sum
tavg: Temporal average
wmin: Window minimum
wmax: Window maximum
wcount: Window count
wsum: Window sum
wavg: Window average
tcentroid: Temporal centroid
mobilitydb_version: Get the version of the MobilityDB extension
mobilitydb_full_version: Get the versions of the MobilityDB extension and its dependencies