15.10 - ST_Dimension - Teradata Database

Returns the dimension of the ST_Geometry type.

Returns a SMALLINT value:

0, for a 0-dimensional geometry

1, for a 1D geometry

2, for a 2D geometry

-1, if the input geometry is empty

All ST_Geometry types.

   SELECT skey 

   FROM sample_shapes

   WHERE shape.ST_Dimension() = 1

   ORDER BY skey;