ST_IsRing Method | Geospatial Data Types | Teradata Vantage - 17.10 - ST_IsRing - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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

Valid Data Types

ST_LineString or GeoSequence

Result Type

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.