15.10 - ST_IsClosed - 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, GeoSequence, or ST_MultiLineString value is closed.

Returns an INTEGER value.

  • 1, if the ST_LineString, GeoSequence, or ST_LineString components of an ST_MultiLineString are closed.
  • 0, if the ST_LineString, GeoSequence, or ST_LineString components of an ST_MultiLineString are not closed, or if the input geometry is empty.
  • ST_LineString, GeoSequence, and ST_MultiLineString

    An ST_LineString value is closed if the start point of the ST_LineString value is equal to the end point.

       SELECT skey
       FROM sample_shapes
       WHERE shape.ST_IsClosed() = 0
       ORDER BY skey;