ST_CurvePolygon( ST_MultiCurve , VARCHAR(128)) constructor

Syntax

NEW ST_CurvePolygon( ST_MultiCurve multi_curve, VARCHAR(128) polygon_format)

Parameters

• multi_curve – A multicurve value containing an exterior ring and (optionally) a set of interior rings.
• polygon_format – A string with the polygon format to use when interpreting the provided curves. Valid formats are 'CounterClockwise', 'Clockwise', and 'EvenOdd'

Returns

ST_CurvePolygon Returns a curve polygon created from the rings in a multilinestrings.

Examples

• Example 1 – 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 ))' ) )

Standards

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