15.10 - ST_NumInteriorRing - 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 interior rings of an ST_Geometry type that represents an ST_Polygon value.

Returns an INTEGER value.

ST_Polygon

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