15.10 - ST_Contains - Teradata Database

Tests if an ST_Geometry value spatially contains another ST_Geometry value.

Argument …	Specifies …
ageometry	the other ST_Geometry value.

Returns an INTEGER value:

1 if the input geometry contains ageometry

0 if the input geometry does not contain ageometry

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, cityName

   FROM sample_cities, sample_streets

   WHERE cityShape.ST_Contains(streetShape) = 1

   ORDER BY cityName;