ST_MultiSurface(ST_Surface,...) constructor

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

Syntax

NEW ST_MultiSurface(surface1[,surface2,...,surfaceN])

Parameters

Name	Type	Description
surface1	ST_Surface	The first surface value of the multi-surface.
surface2,...,surfaceN	ST_Surface	Additional surface values of the multi-surface.

Remarks

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

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

Note

By default, ST_MultiSurface 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 MultiSurface (((0 0, 1 0, 1 1, 0 1, 0 0))).

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

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

SELECT NEW ST_MultiSurface( 
        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.