15.10 - ST_IsClosed - Teradata Database

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;