ST_NUMGEOMETRIES
You are viewing an old version of this article. View
the current version here.
MariaDB starting with 5.3.3
ST_NUMGEOMETRIES was added as a synonym for NUMGEOMETRIES in MariaDB 5.3.3.
Syntax
ST_NumGeometries(gc) NumGeometries(gc)
Description
Returns the number of geometries in the GeometryCollection gc
.
ST_NumGeometries()
and NumGeometries()
are synonyms.
Example
SET @gc = 'GeometryCollection(Point(1 1),LineString(2 2, 3 3))'; SELECT NUMGEOMETRIES(GeomFromText(@gc)); +----------------------------------+ | NUMGEOMETRIES(GeomFromText(@gc)) | +----------------------------------+ | 2 | +----------------------------------+
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.