Constructs a geometry collection from a text representation.
NEW ST_GeomCollection(text-representation[, srid])
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 WKT or 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)))')