ST_GeomCollFromText()

ST_GeomCollFromText creates a GEOMETRYCOLLECTION from WKT.

Syntax

ST_GeomCollFromText(wkt)

Aliases: ST_GeomCollFromTxt(), ST_GeometryCollectionFromText().

Arguments

Argument

Description

wkt

VARCHAR WKT.

Return Value

Returns a GEOMETRY value.

Usage Notes

Examples

DROP DATABASE IF EXISTS geo_io_example;
CREATE DATABASE geo_io_example;
USE geo_io_example;

SELECT ST_AsText(ST_GeomCollFromText('GEOMETRYCOLLECTION(POINT(1 1))')) AS collection;

DROP DATABASE geo_io_example;

See Also

ST_GeomCollFromWKB(), ST_GeomFromText().