GEOMETRYCOLLECTION()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Enterprise Server
Topics on this page:
Overview
Constructs a WKB GeometryCollection. If any argument is not a well-formed WKB representation of a geometry, the return value is NULL.
EXAMPLES
CREATE TABLE geomcoll (c1 GEOMETRYCOLLECTION);
INSERT INTO geomcoll VALUES
(GeometryCollection(Point(1,0),
LineString(Point(1,2), Point(2,3)),
MultiLineString(
LineString(Point(1,1), Point(2,2), Point(3,3)),
LineString(Point(4,4), Point(5,5)),
LineString(Point(1,1), Point(2,2), Point(3,3)))));
SELECT ST_AsText(c1) FROM geomcoll;
+-----------------------------------------------------------------------------------------------------------+
| ST_AsText(c1) |
+-----------------------------------------------------------------------------------------------------------+
| GEOMETRYCOLLECTION(POINT(1 0),LINESTRING(1 2,2 3),MULTILINESTRING((1 1,2 2,3 3),(4 4,5 5),(1 1,2 2,3 3))) |
+-----------------------------------------------------------------------------------------------------------+
SELECT ST_IsEmpty(GeometryCollection(Point(1,1),
LineString(Point(2,2), Point(3,3)))) AS result;
+--------+
| result |
+--------+
| 0 |
+--------+
CHANGE HISTORY
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.