NEW ST_Polygon(exterior-ring[,interior-ring1,...,interior-ringN])

Creates a polygon from a linestring representing the exterior ring and a list (possibly empty) of linestrings representing interior rings. All of the specified linestring values must have the same SRID. The resulting polygon is constructed with this common SRID.

All of the supplied linestrings must be non-empty and have the same answer for Is3D and IsMeasured. The polygon is 3D if all of the linestrings are 3D, and the polygon is measured if all of the linestrings are measured.

The ability to specify a varying length list of interior rings is a vendor extension.

The following returns Polygon ((-5 -1, 5 -1, 0 9, -5 -1), (-2 0, 0 4, 2 0, -2 0)) (a triangle with a triangular hole).

SELECT NEW ST_Polygon(
    NEW ST_LineString ('LineString (-5 -1, 5 -1, 0 9, -5 -1)'),
    NEW ST_LineString ('LineString (-2 0, 0 4, 2 0, -2 0)'))