15.10 - ST_Difference - Teradata Database

Teradata Database SQL Geospatial Types

Teradata Database
Programming Reference

Returns an ST_Geometry value that represents the point set difference of two ST_Geometry values.


Argument …

Specifies …


the other ST_Geometry value.

Returns an ST_Geometry type where the representation is one of the possible set of types in the following table, depending on the parameter types.


Teradata Database converts GeoSequence types that are involved in the ST_Difference method to ST_LineString values. Therefore, ST_Difference never returns a GeoSequence type.

All ST_Geometry types except geometry collections.

Note: This method can be called on 3D geometries (those that include z coordinates). However, the z coordinate is ignored in method calculations. Consequently, any z coordinates returned by this method should be ignored. Teradata recommends using the Make_2D method to strip out the z coordinates of the return value.

   SELECT shape.ST_Difference(NEW ST_Geometry('LINESTRING(2 2, 3 2, 4 1)'))
   FROM sample_shapes
   WHERE skey = 1067;