This topic describes the ST_NumGeometries function. This function returns the number of geometries.

Syntax

int4 ST_NumGeometries(meshgeom geom);
int4 ST_NumGeometries(sfmesh sfmeshObject);

Parameters

ParameterDescription
geomThe meshgeom object.
sfmeshObjectThe sfmesh object.

Description

The function returnsthe number of geometries.

Examples

  • Example 1
    select ST_NumGeometries('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1), INDEX((0,1,2),(1,2,3)))))'::meshgeom);

------------------
                1
  • Example 2
    select ST_NumGeometries('MESHGEOM(PATCH(INDEXSURFACE(VERTEX(0 0 2,0 10 3,10 10 1,10 0 1), INDEX((0,1,2),(1,2,3))), POINT(0 1 2)))'::meshgeom);

------------------
                2