ST_CurvePolygon(ST_MultiCurve[, VARCHAR(128)]) constructor

NEW ST_CurvePolygon(multi-curve[, polygon-format])

Name	Type	Description
multi-curve	ST_MultiCurve	A multicurve value containing an exterior ring and (optionally) a set of interior rings.
polygon-format	VARCHAR(128)	A string with the polygon format to use when interpreting the provided curves. Valid formats are 'CounterClockwise', 'Clockwise', and 'EvenOdd'

Creates a curve polygon from a multi curve containing an exterior ring and an optional list of interior rings.

If specified, the polygon-format parameter selects the algorithm the server uses to determine whether a ring is an exterior or interior ring. If not specified, the polygon format of the spatial reference system is used.

For additional information about polygon-format, see POLYGON FORMAT clause, CREATE SPATIAL REFERENCE SYSTEM statement.

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.

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

The following returns the result CurvePolygon (CircularString (-2 0, 1 -3, 4 0, 1 3, -2 0), (0 0, 1 1, 2 0, 0 0)) (a circular curve polygon with a triangular hole).

SELECT NEW ST_CurvePolygon( NEW ST_MultiCurve( 
    'MultiCurve(CircularString( -2 0, 4 0, -2 0 ),(0 0, 2 0, 1 1, 0 0 ))' ) )

ST_CurvePolygon(ST_MultiCurve[, VARCHAR(128)]) constructor

Syntax

Parameters

Remarks

Note

Standards and compatibility

Example