ST_NumGeometries

更新时间:
复制 MD 格式

Returns the number of geometries in a meshgeom or sfmesh object.

Syntax

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

Parameters

ParameterDescription
geomThe meshgeom object.
sfmeshObjectThe sfmesh object.

Description

ST_NumGeometries returns the number of geometries in a meshgeom or sfmesh object.

Examples

Example 1: A MESHGEOM containing a single PATCH returns 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
);

Result:

 st_numgeometries
------------------
                1

Example 2: A MESHGEOM containing one PATCH and one POINT returns 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
);

Result:

 st_numgeometries
------------------
                2