ST_CurvePolygon(ST_Curve,...) constructor

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

Name	Type	Description
exterior-ring	ST_Curve	The exterior ring of the curve polygon
interior-ring1,...,interior-ringN	ST_Curve	Interior rings of the curve polygon

Creates a curve polygon from a curve representing the exterior ring and a list (possibly empty) of curves representing interior rings. All of the specified rings must have the same SRID. The polygon is created with this common SRID. All of the supplied rings must be non-empty and have the same answer for Is3D and IsMeasured. The polygon is 3D if all of the points are 3D, and the polygon is measured if all of the points are measured.

Note

By default, ST_CurvePolygon uses the original format for a geometry, if it is available. Otherwise, the internal format is used. For more information about internal and original formats, see STORAGE FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.

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

SQL/MM (ISO/IEC 13249-3: 2006) 8.2.2

The following returns CurvePolygon ((-5 -1, 5 -1, 0 9, -5 -1), CircularString (-2 2, -2 4, 2 4, 2 2, -2 2)) (a triangle with a circular hole).

SELECT NEW ST_CurvePolygon(
    NEW ST_LineString ('LineString (-5 -1, 5 -1, 0 9, -5 -1)'),
    NEW ST_CircularString ('CircularString (-2 2, -2 4, 2 4, 2 2, -2 2)'))

ST_CurvePolygon(ST_Curve,...) constructor

Syntax

Parameters

Remarks

Note

Standards and compatibility

Example