15.10 - ST_GeometryType - Teradata Database

Returns the ST_Geometry type of the ST_Geometry value.

Returns a VARCHAR(128) value that indicates the ST_Geometry type. The return value can be any of these strings:

'ST_Point'

'ST_LineString'

'ST_Polygon'

'ST_MultiPoint'

'ST_MultiLineString'

'ST_MultiPolygon'

'ST_GeomCollection'

'GeoSequence'

All ST_Geometry types.

   SELECT skey

   FROM sample_shapes

   WHERE shape.ST_GeometryType() = 'ST_LineString';