ST_NumGeometries

更新时间: 2026-04-12 04:09:51

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
上一篇: ST_NPoints 下一篇: ST_GeometryN
阿里云首页 云原生数据库 PolarDB 相关技术圈