15.10 - ST_Touches - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

Tests if an ST_Geometry value spatially touches another ST_Geometry value.

 

Argument …

Specifies …

ageometry

the other ST_Geometry value.

Returns an INTEGER value:

  • 1, if the geometries touch
  • 0, if the geometries do not touch
  • 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.

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

       SELECT streetName
       FROM sample_streets
       WHERE streetShape.ST_Touches(
          NEW ST_Geometry('LINESTRING(2 2, 3 2, 4 1)')) = 1
       ORDER BY streetName;