15.10 - ST_Equals - Teradata Database

Tests if an ST_Geometry value is spatially equal to another ST_Geometry value.

Argument …	Specifies …
ageometry	the other ST_Geometry value.

Returns an INTEGER value:

1, if the geometries are spatially equal

0, if the geometries are not spatially equal

All ST_Geometry types.

Use of a geospatial index can greatly improve the performance of queries that use this method.

   SELECT streetName

   FROM sample_streets

   WHERE streetShape.ST_Equals(

      NEW ST_Geometry('LINESTRING(2 2, 3 2, 4 1)')) = 1

   ORDER BY streetName;