15.10 - Intersects - Teradata Database

Teradata Database SQL Geospatial Types

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

Tests if an MBR or MBB value spatially intersects another value of the same data type.

 

Argument …

Specifies …

other

the other value, which must be the same data type on which the method is called.

 

IF the value of this MBR …

THEN Intersects returns …

spatially intersects the value of the other argument

an INTEGER value of 1.

does not spatially intersect the value of the other argument

an INTEGER value of 0.

This method can be called on MBR and MBB data types.

   SELECT skey 
   FROM sample_MBRs
   WHERE shape_mbr.Intersects(NEW MBR(5, 5, 10, 10)) = 1;

   SELECT skey
   FROM sample_MBBs
   WHERE shape_mbb.Intersects(NEW MBB(5, 5, 5, 10, 10, 10)) = 1;