circle

Computes smallest circle enclosing box.

English manual coverage begins with PostgreSQL 7.1. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

group: geometry
group label: Geometric Functions And Operators
lang: en
layout: table-new
pages: functions-geometry.html
prose only: false

Definition PG 18

Computes smallest circle enclosing box.

Signatures and overloads

circle ( box ) → circle → circle

Computes smallest circle enclosing box.

circle ( point, double precision ) → circle → circle

Constructs circle from center and radius.

circle ( polygon ) → circle → circle

Converts polygon to circle. The circle's center is the mean of the positions of the polygon's points, and the radius is the average distance of the polygon's points from that center.

Compare versions

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · wiki-repair-20261023:239e22b36f8476cc3cef9308fdb6fd121faf5290b1335b39ced69265a9922088

Text language: en · wiki-repair-20261023:239e22b36f8476cc3cef9308fdb6fd121faf5290b1335b39ced69265a9922088