ST_CONVEXHULL

Returns the convex hull of a GEOMETRY object.

Syntax

ST_CONVEXHULL(<geometry>)

Arguments

Return Type

GEOMETRY.

Examples

SELECT ST_ASTEXT(
  ST_CONVEXHULL(
    TO_GEOMETRY('POLYGON((0 0, 2 0, 2 2, 0 2, 0 0))')
  )
) AS hull;

╭────────────────────────────────╮
│              hull              │
├────────────────────────────────┤
│ POLYGON((2 0,2 2,0 2,0 0,2 0)) │
╰────────────────────────────────╯