ST_MultiPolygon( ST_MultiLineString , VARCHAR(128)) constructor

Syntax

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

Parameters

• multi_linestring – A multilinestring value containing exterior rings 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_MultiPolygon Returns a multi-polygon from the specified multilinestring.

Examples

• Example 1 – The following returns MultiPolygon (((-4 -4, 4 -4, 4 4, -4 4, -4 -4), (-2 1, -3 3, -1 3, -2 1)), ((6 -4, 14 -4, 14 4, 6 4, 6 -4), (8 1, 7 3, 9 3, 8 1))) (two square polygons each with a triangular hole).

  SELECT NEW ST_MultiPolygon(
  NEW ST_MultiLineString ('MultiLineString ((-4 -4, 4 -4, 4 4, -4 4, -4 -4), (-2 1, -3 3, -1 3, -2 1), (6 -4, 14 -4, 14 4, 6 4, 6 -4), (8 1, 7 3, 9 3, 8 1))'))

Standards

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