ST_GeomCollection(LONG VARCHAR[, INT]) constructor

NEW ST_GeomCollection(text-representation[, srid])

Name	Type	Description
text-representation	LONG VARCHAR	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	INT	The SRID of the result. If not specified, the default is 0.

Constructs a geometry collection from a character string representation. The database server determines the input format by inspecting the provided string.

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

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)))')

ST_GeomCollection(LONG VARCHAR[, INT]) constructor

Syntax

Parameters

Remarks

Standards and compatibility

Example