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
settypeFromBinary
, spantypeFromBinary
, spansettypeFromBinary
: Input from a Well-Known Binary (WKB) representation
settypeFromHexWKB
, spantypeFromHexWKB
, spansettypeFromHexWKB
: Input from an 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
: Return the number of values
startValue
, endValue
, valueN
: Return the start, end, or n-th value
getValues
: Return the values
numSpans
: Return the number of composing spans
startSpan
, endSpan
, spanN
: Return the start, end, or n-th span
spans
: Return the spans
numDates
, numTimestamps
: Return the number of different dates or timestamps
startDate
, endDate
, dateN
, startTimestamp
, endTimestamp
, timestampN
: Return the start, end, or n-th date or timestamp
dates
, timestamps
: Return the different dates or timestamps
shift
: Shift by a value or interval
scale
: Scale by a value or interval
shiftScale
: Shift and scale by the values or intervals
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
concat
: Text concatenation
tprecision
: Set the temporal precision to the interval with respect to the origin
SRID
: Return the spatial reference identifier
setSRID
: Set the spatial reference identifier
transform
, transformPipeline
: Transform to a different spatial reference
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
tCount
: Temporal count
extent
: Bounding span
setUnion
, spanUnion
: Aggregate union