asText
: Return the Well-Known Text (WKT) representation
asBinary
: Return the Well-Known Binary (WKB) or the Hexadecimal Well-Known Binary (HexWKB) representation
settypeFromBinary
, spantypeFromBinary
, spansettypeFromBinary
: Input from the Well-Known Binary (WKB) representation
settypeFromHexWKB
, spantypeFromHexWKB
, spansettypeFromHexWKB
: Input from the Hexadecimal Well-Known Binary (HexWKB) representation
::
, set(base)
, span(base)
, spanset(base)
: Convert a base value to a set, span, or span set value
::
, spanset(set)
: Convert a set value to a span set value
::
, spanset(span)
: Convert a span value to a span set value
::
, range(span)
, span(range)
: Convert a span value to and from a PostgreSQL range value
::
, multirange(spanset)
, spanset(multirange)
: Convert a span set value to and from a PostgreSQL multirange value
memSize
: Return the memory size in bytes
lower
, upper
: Return the lower or upper bound
lowerInc
, upperInc
: Is the lower or upper bound inclusive?
width
: Return the width of the span as a float
duration
: Return the duration
span
: Return the bounding span of the set or span set ignoring the potential time gaps
numValues
, getValues
: Return the (number of) values
startValue
, endValue
, valueN
: Return the start, end, or n-th value
numSpans
, spans
: Return (the number of) composing spans
startSpan
, endSpan
, spanN
: Return the start, end, or n-th span
numDates
, dates
: Return the (number of) different dates
startDate
, endDate
, dateN
: Return the start, end, or n-th date
numTimestamps
, timestamps
: Return the (number of) different timestamps
startTimestamp
, endTimestamp
, timestampN
: Return the start, end, or n-th timestamp
shift
, scale
, shiftScale
: Shift and/or scale by a value or an interval
floor
, ceil
: Round down or up to the lowest integer
round
: Round to a number of decimal places
degrees
, radians
: Transform to degrees or radians
lower
, upper
, initcap
: Transform to lowercase, uppercase, or initcap
||
: Text concatenation
tprecision
: Set the temporal precision to the interval with respect to the origin
SRID
, setSRID
: Return or set the spatial reference identifier
transform
, transformPipeline
: Transform to a spatial reference identifier
+
, -
, *
: Union, difference, and intersection of sets or spans
splitNSpans
: Return an array of N spans obtained by merging the elements of a set or the spans of a spanset
splitEachNSpans
: Return an array of spans obtained by merging N consecutive elements of a set or N consecutive spans of a spanset
<->
: Return the smallest distance ever
=
, <>
, <
, >
, <=
, >=
: Traditional comparisons
tCount
: Temporal count
extent
: Bounding span
setUnion
, spanUnion
: Aggregate union