↑↓ 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.

Reading PG 18current·documented in 27 of 27 versions, 7.1 to 20

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 4
  1. 12 → 13 changed
  2. 8.0 → 8.1 changed
  3. 7.4 → 8.0 changed
  4. 7.3 → 7.4 changed

Definition snapshot: b7bd9cda · English manual source