ST_MultiPolygon( ST_Polygon , ST_Polygon ) constructor

Syntax

NEW ST_MultiPolygon( ST_Polygon polygon1, ST_Polygon polygoni)

Parameters

• polygon1 – The first polygon value of the multi-polygon.
• polygoni – Additional polygon values of the multi-polygon.

Returns

ST_MultiPolygon A multi-polygon containing the provided polygon values.

Examples

• Example 1 – The following example returns the result MultiPolygon (((0 0, 1 0, 1 1, 0 1, 0 0))).

  SELECT NEW ST_MultiPolygon( NEW ST_Polygon('Polygon ((0 0, 0 1, 1 1, 1 0, 0 0))' )  )

  The following example returns the result MultiPolygon (((0 0, 1 0, 1 1, 0 1, 0 0)), ((5 5, 10 5, 10 10, 5 10, 5 5))).

  SELECT NEW ST_MultiPolygon(
  NEW ST_Polygon('Polygon ((0 0, 0 1, 1 1, 1 0, 0 0))' ),
  NEW ST_Polygon('Polygon ((5 5, 5 10, 10 10, 10 5, 5 5))' )  )

Standards

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