pcpoint: Build a 2D or 3D pcpoint from x/y(/z) coordinates

pcpatch: Build a pcpatch from a variadic list of pcpoints

pcid: Return the schema id of a pcpoint or pcpatch

getX, getY, getZ: Return a coordinate of a pcpoint

getDim: Return any named dimension of a pcpoint

SRID: Return the spatial reference identifier of a pcpoint or pcpatch

set: Construct a set from an array of pcpoint or pcpatch values sharing the same pcid

tpcbox, tpcbox_z, tpcbox_t, tpcbox_xt, tpcbox_zt: Construct a tpcbox from explicit X/Y/Z/T bounds and a pcid

tpcbox(pcpoint): Convert a pcpoint to a degenerate (zero-extent) tpcbox

tpcbox(pcpatch): Convert a pcpatch to a tpcbox using the patch's embedded PCBOUNDS

hasX, hasZ, hasT: Return whether a tpcbox has the X/Y, Z, or T dimensions set

xmin, xmax, ymin, ymax, zmin, zmax: Return a coordinate bound of a tpcbox

tmin, tmax: Return a temporal bound of a tpcbox

pcid, SRID: Return the schema id and SRID of a tpcbox

round: Return a tpcbox with coordinates rounded to a given number of decimal digits

setSRID: Return a tpcbox with the SRID overwritten

tpcbox_union, +: Return the union of two tpcboxes

tpcbox_intersection, *: Return the intersection of two tpcboxes

&&: Return true if two tpcboxes overlap

@>: Return true if the first tpcbox contains the second

<@: Return true if the first tpcbox is contained in the second

~=: Return true if two tpcboxes are exactly equal

-|-: Return true if two tpcboxes are adjacent

<<, &<, >>, &>: X-axis position operators

<<|, &<|, |>>, |&>: Y-axis position operators

<</, &</, />>, /&>: Z-axis position operators

<<#, &<#, #>>, #&>: Time-axis position operators

=, <>, <, >, <=, >=: Traditional comparisons

asText, tpcpoint::text: Return the text representation, or cast to text

tpcpoint: Construct a temporal pcpoint of instant subtype

tpcpointSeq: Construct a temporal pcpoint of sequence subtype

tpcpointSeqSet: Construct a temporal pcpoint of sequence-set subtype

pcid: Return the pgPointCloud schema id shared by all instants

SRID: Return the SRID inherited from the schema

getX, getY, getZ: Project a tpcpoint onto a spatial dimension, yielding a tfloat

getDim: Project a tpcpoint onto any named schema dimension, yielding a tfloat

tpcpoint::tgeompoint: Cast a tpcpoint to a temporal geometry point

tpcpointInst, tpcpointSeq, tpcpointSeqSet: Transform a tpcpoint to another subtype

setInterp: Transform a tpcpoint to another interpolation

=, <>, <, >, <=, >=: Traditional comparisons

eEq, aEq, eNe, aNe, ?=, %=, ?<>, %<>: Ever and always equality and inequality comparisons

tEq, tNe, #=, #<>: Temporal equality and inequality comparisons

atValue, minusValue, atValues, minusValues: Restrict to (the complement of) a value or a set of values

atTime, minusTime: Restrict to (the complement of) a time selector

atTpcbox, minusTpcbox: Restrict to (the complement of) the extent of a tpcbox

beforeTimestamp, afterTimestamp: Restrict to the instants before or after a timestamp

insert, update: Insert a tpcpoint into another one, or update another one with it

deleteTime: Delete a time selector from a tpcpoint

appendInstant, appendSequence: Append an instant or a sequence to a tpcpoint

unnest: Return the distinct values of a tpcpoint with the span set on which each of them is taken

timeSplit: Split a tpcpoint into fragments, one per time bin

&&, @>, <@, ~=, -|-: Topological operators

<<, >>, <<|, |>>, <</, />>, <<#, #>>: Position operators

|=|, nearestApproachDistance: Nearest-approach distance, KNN-orderable

eIntersects, aIntersects: Ever / always intersects

eDisjoint, aDisjoint: Ever / always disjoint

eDwithin, aDwithin: Ever / always within distance

asText, tpcpatch::text: Return the text representation, or cast to text

tpcpatch: Construct a temporal pcpatch of instant subtype

tpcpatchSeq: Construct a temporal pcpatch of sequence subtype

tpcpatchSeqSet: Construct a temporal pcpatch of sequence-set subtype

startNumPoints, endNumPoints: Return the number of points in the first or last instant's patch

numPoints: Return the total number of points across all instants

points: Set-returning function emitting one row per (timestamp, pcpoint)

tpcpatchInst, tpcpatchSeq, tpcpatchSeqSet: Transform a tpcpatch to another subtype

setInterp: Transform a tpcpatch to another interpolation

atValue, minusValue, atValues, minusValues: Restrict to (the complement of) a value or a set of values

atTpcbox, minusTpcbox: Restrict to the instants whose patch overlaps a tpcbox (patch-level)

atTpcboxFine, minusTpcboxFine: Restrict to (the complement of) the points inside a tpcbox (per-point)

atGeometry, minusGeometry: Restrict to (the complement of) the points intersecting a 2D geometry

beforeTimestamp, afterTimestamp: Restrict to the instants before or after a timestamp

insert, update: Insert a tpcpatch into another one, or update another one with it

deleteTime: Delete a time selector from a tpcpatch

appendInstant, appendSequence: Append an instant or a sequence to a tpcpatch

unnest: Return the distinct values of a tpcpatch with the span set on which each of them is taken

timeSplit: Split a tpcpatch into fragments, one per time bin

eIntersects: Return true if at least one point in any instant intersects a geometry

&&, @>, <@, ~=, -|-: Topological operators

<<, >>, <<|, |>>, <</, />>, <<#, #>>: Position operators

|=|, nearestApproachDistance: Nearest-approach distance, KNN-orderable