select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

FUNCTIONS / GEOMETRIC FUNCTIONS AND OPERATORS

Constructs point from its coordinates.

Signatures & examples

point ( double precision, double precision ) → point
Constructs point from its coordinates.
point(23.4, -44.5) → (23.4,-44.5)
point ( box ) → point
Computes center of box.
point(box '(1,0),(-1,0)') → (0,0)
point ( circle ) → point
Computes center of circle.
point(circle '<(0,0),2>') → (0,0)
point ( lseg ) → point
Computes center of line segment.
point(lseg '[(-1,0),(1,0)]') → (0,0)
point ( polygon ) → point
Computes center of polygon (the mean of the positions of the polygon's points).
point(polygon '((0,0),(1,1),(2,0))') → (1,0.3333333333333333)
Version history 1
  1. PG 12 → 13changed

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source