ST_GeomCollection(LONG VARCHAR[, INT]) constructor

Syntax

NEW ST_GeomCollection(LONG VARCHAR text_representation[, INT srid])

Parameters

• text_representation – A string containing the text representation of a geometry collection. The input can be in any supported text input format, including Well Known Text (WKT) or Extended Well Known Text (EWKT).
• srid – The SRID of the result. If not specified, the default is 0.

Returns

ST_GeomCollection Returns an ST_GeomCollection value constructed from the source string.

Examples

• Example 1 – The following returns GeometryCollection (CircularString (5 10, 10 12, 15 10), Polygon ((10 -5, 15 5, 5 5, 10 -5))).

  SELECT NEW ST_GeomCollection('GeometryCollection (CircularString (5 10, 10 12, 15 10), Polygon ((10 -5, 15 5, 5 5, 10 -5)))')

Standards

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