Skip navigation links
18.5.3 Fonctions qui génèrent des formes géométriques à partir d'autres formes »
Section Navigation      [Toggle]

18.5.2.7. Fonctions d'analyse des lignes GeometryCollection

  • NumGeometries(gc)

    Retourne le nombre de formes géométriques qui constituent l'objet GeometryCollection gc. 

    mysql> SELECT NumGeometries(GeomFromText('GeometryCollection(Point(1 1),LineString(2 2, 3 3))'));
+------------------------------------------------------------------------------------+
| NumGeometries(GeomFromText('GeometryCollection(Point(1 1),LineString(2 2, 3 3))')) |
+------------------------------------------------------------------------------------+
|                                                                                  2 |
+------------------------------------------------------------------------------------+

  • GeometryN(gc,n)

    Retourne le n-ième objet constituant l'objet GeometryCollection gc. La numérotation commence à 1. 

    mysql> SELECT AsText(GeometryN(GeomFromText('GeometryCollection(Point(1 1),LineString(2 2, 3 3))'),1));
+------------------------------------------------------------------------------------------+
| AsText(GeometryN(GeomFromText('GeometryCollection(Point(1 1),LineString(2 2, 3 3))'),1)) |
+------------------------------------------------------------------------------------------+
| POINT(1 1)                                                                               |
+------------------------------------------------------------------------------------------+

This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.