ttypeinst: Constructor for temporal types of instant subtype

ttypei: Constructor for temporal types of instant set subtype

ttypeseq: Constructor for temporal types of sequence subtype

ttypes: Constructor for temporal types of sequence set subtype

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

ttypeinst, ttypei, ttypeseq, ttypes: 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

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

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

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

fromMFJSON: Input a temporal point from a Moving Features JSON representation

fromEWKB: Input a temporal point from an Extended Well-Known Binary (EWKB) representation

SRID: Get the spatial reference identifier

setSRID: Set the spatial reference identifier

transform: Transform to a different spatial reference

setPrecision: Round the coordinate values to a number of decimal places

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

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

nearestApproachInstant: Get the instant of the first temporal point at which the two arguments are at the nearest distance

nearestApproachDistance: Get the smallest distance ever

shortestLine: Get the line connecting the nearest approach point

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

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?

#=: Temporal equal

#<>: Temporal different

#<: Temporal less than

#>: Temporal greater than

#<=: Temporal less than or equal to

#>=: Temporal greater than or equal to

+: Temporal addition

-: Temporal subtraction

*: Temporal multiplication

/: Temporal division

round: Round the values to a number of decimal places

degrees: Convert from radians to degrees

derivative: Get the derivative over time of the temporal float in units per second

&: Temporal and

|: Temporal or

~: Temporal not

||: Temporal text concatenation

upper: Transform to uppercase

lower: Transform to lowercase

|=|: Get the smallest distance ever

<->: Get the temporal distance

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