select open change scope Open full search

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

FUNCTIONS / GEOMETRIC FUNCTIONS AND OPERATORS

Computes box inscribed within the circle.

Signatures & examples

box ( circle ) → box
Computes box inscribed within the circle.
box(circle '<(0,0),2>') → (1.414213562373095,1.414213562373095),​(-1.414213562373095,-1.414213562373095)
box ( point ) → box
Converts point to empty box.
box(point '(1,0)') → (1,0),(1,0)
box ( point, point ) → box
Converts any two corner points to box.
box(point '(0,1)', point '(1,0)') → (1,1),(0,0)
box ( polygon ) → box
Computes bounding box of polygon.
box(polygon '((0,0),(1,1),(2,0))') → (2,1),(0,0)
Version history 2
  1. PG 12 → 13changed
  2. PG 9.4 → 9.5changed

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