15.10 - ST_NumGeometries - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

Returns the number of distinct geometries that constitute a composite geometry type (ST_GeomCollection, ST_MultiPoint, ST_MultiLineString, or ST_MultiPolygon).

Returns an INTEGER value.

ST_GeomCollection, ST_MultiPoint, ST_MultiLineString, and ST_MultiPolygon

   SELECT skey
   FROM sample_shapes
   WHERE shape.ST_NumGeometries() < 4
   ORDER BY skey;