GEOMETRYCOLLECTION()

Overview

Constructs a WKB GeometryCollection. If any argument is not a well-formed WKB representation of a geometry, the return value is NULL.

See also: Functions in 10.6 ES, in 10.6 CS, in 10.5 ES, in 10.5 CS, in 10.4 ES, in 10.4 CS, in 10.3 ES, in 10.3 CS, in 10.2 ES, and in 10.2 CS

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

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.6 Community

  • Present starting in MariaDB Community Server 10.6.0.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.5 Community

  • Present starting in MariaDB Community Server 10.5.0.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

10.4 Community

  • Present starting in MariaDB Community Server 10.4.0.

10.3 Enterprise

  • Present starting in MariaDB Enterprise Server 10.3.16-1.

10.3 Community

  • Present starting in MariaDB Community Server 10.3.0.

10.2 Enterprise

  • Present starting in MariaDB Enterprise Server 10.2.25-1.

10.2 Community

  • Present starting in MariaDB Community Server 10.2.0.

EXTERNAL REFERENCES