ST_GEOMETRYTYPE()

Overview

A description for this Function has not yet been added to this Documentation.

See also: Functions in 10.6 ES, in 10.5 ES, and in 10.4 ES

EXAMPLES

SELECT ST_GeometryType(ST_GeomFromText('POINT(1 5)'));
+------------------------------------------------+
| ST_GeometryType(ST_GeomFromText('POINT(1 5)')) |
+------------------------------------------------+
| POINT                                          |
+------------------------------------------------+
SET @a = ST_GeomFromText('POLYGON((0 0,5 0,5 5,0 5,0 0),(1 1,2 1,2 2,1 2,1 1))');
SELECT ST_GeometryType(@a);
+---------------------+
| ST_GeometryType(@a) |
+---------------------+
| POLYGON             |
+---------------------+

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Present starting in MariaDB Enterprise Server 10.5.3-1.

10.4 Enterprise

  • Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES