ST_GeomCollection( ST_Geometry , ST_Geometry ) constructor

Syntax

NEW ST_GeomCollection( ST_Geometry geo1, ST_Geometry geoi)

Parameters

• geo1 – The first geometry value of the geometry collection.
• geoi – Additional geometry values of the geometry collection.

Returns

ST_GeomCollection A geometry collection containing the provided geometry values.

Examples

• Example 1 – 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 ) )

Standards

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