ST_GeomCollection(ST_Geometry,...) constructor

Constructs a geometry collection from a list of geometry values.

Syntax

NEW ST_GeomCollection(geo1,[geo2,...,geoN])

Parameters

Name	Type	Description
geo1	ST_Geometry	The first geometry value of the geometry collection.
geo2,...,geoN	ST_Geometry	Additional geometry values of the geometry collection.

Remarks

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

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

Note

By default, ST_GeomCollection 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 geometry collection containing the single point 'Point (1 2)'

SELECT NEW ST_GeomCollection( NEW ST_Point( 1.0, 2.0 ) )

The following returns a geometry collection containing two points 'Point (1 2)' and 'Point (3 4)'

SELECT NEW ST_GeomCollection( NEW ST_Point( 1.0, 2.0 ), NEW ST_Point( 3.0, 4.0 ) )

Discuss this page in DocCommentXchange.