ST_Contains Method | Geospatial Data Types | Teradata Vantage - 17.10 - ST_Contains Method - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Tests if an ST_Geometry value spatially contains another ST_Geometry value.

Valid Data Types

All ST_Geometry types except geometry collections.

This method can be called on 3D geometries (those that include z coordinates). However, the z coordinate is ignored in method calculations.

Result Type

Returns an INTEGER value:

  • 1 if the input geometry contains ageometry
  • 0 if the input geometry does not contain ageometry