15.10 - ST_InteriorRingN - Teradata Database

Teradata Database SQL Geospatial Types

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

Returns the specified interior ring of an ST_Geometry type that represents an ST_Polygon value.

 

Argument …

Specifies …

aposition

an INTEGER value for the requested interior ring, where the position of the first interior ring is 1.

Returns an ST_LineString.

ST_Polygon

Note: This method can be called on 3D geometries (those that include z coordinates). However, the z coordinate is ignored in method calculations. Consequently, any z coordinates returned by this method should be ignored. Teradata recommends using the Make_2D method to strip out the z coordinates of the return value.

   SELECT shape.ST_InteriorRingN(2)
   FROM sample_shapes
   WHERE skey = 992;