ST_MultiPolygon(ST_Polygon,...) constructor

Constructs a multi-polygon from a list of polygon values.

Syntax

NEW ST_MultiPolygon(polygon1,[polygon2,...,polygonN])

Parameters

Name	Type	Description
polygon1	ST_Polygon	The first polygon value of the multi-polygon.
polygon2,...,polygonN	ST_Polygon	Additional polygon values of the multi-polygon.

Remarks

Constructs a multi-polygon from a list of polygon values. All of the supplied polygon values must have the same SRID, and the multi-polygon is constructed with this common SRID.

All of the supplied polygon values must have the same answer for Is3D and IsMeasured. The multi-polygon is 3D if all of the polygon values are 3D, and the multi-polygon is measured if all of the polygon values are measured.

Note

By default, ST_MultiPolygon 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.

Standards and compatibility

Example

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 returns a multi-surface equivalent to 'MultiPolygon (((0 0, 0 1, 1 1, 1 0, 0 0)), ((5 5, 5 10, 10 10, 10 5, 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))' )  )

Discuss this page in DocCommentXchange.