15.10 - ST_IsRing - Teradata Database

Teradata Database SQL Geospatial Types

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

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;