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 returns a multi-surface equivalent to 'MultiSurface (((0 0, 0 1, 1 1, 1 0, 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.