15.10 - ST_IsRing - Teradata Database

Tests if an ST_Geometry type that represents an ST_LineString or a GeoSequence value is a ring.

Returns an INTEGER value:

1 if the ST_LineString or GeoSequence value is simple (has no anomalous geometric points, such as self intersection tangency) and is closed (the start point of the ST_LineString value is equal to the end point)

0 in all other cases.

ST_LineString or GeoSequence

ST_IsRing returns zero if the geometry value passed to it is the empty set.

   SELECT skey

   FROM sample_shapes

   WHERE shape.ST_IsRing() = 0

   ORDER BY skey;