ST_Polygon( ST_MultiLineString , VARCHAR(128)) constructor

Syntax

NEW ST_Polygon( ST_MultiLineString multi_linestring, VARCHAR(128) polygon_format)

Parameters

• multi_linestring – A multilinestring 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 linestrings. Valid formats are 'CounterClockwise', 'Clockwise', and 'EvenOdd'

Returns

ST_Polygon Returns a polygon created from the rings in a multilinestrings.

Examples

• Example 1 – 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_MultiLineString ('MultiLineString ((-5 -1, 5 -1, 0 9, -5 -1), (-2 0, 0 4, 2 0, -2 0))'))

Standards

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