This SQL element is a shortcut for the User Defined Method SQL element with the User Defined Type field set to MBR (Minimum Bounding Rectangle). An MBR defines the minimum sized rectangle that can surround a two-dimensional geometric object. Selecting this element will display a listing of methods for the MBR type, described in the following table.
| Function | Description |
|---|---|
| Constructor Method(s) | Returns an MBR or MBB value (depending on constructor method). MBB constructor requires Teradata 15.00 or later.
|
| INTERSECTS | Tests if an MBR or MBB value spatially intersects another value of the same data type. |
| XMIN | Returns the minimum x coordinate value of an MBR or MBB:
|
| YMIN | Returns the minimum y coordinate value of an MBR or MBB:
|
| XMAX | Returns the maximum x coordinate value of an MBR or MBB:
|
| YMAX | Returns the maximum y coordinate value of an MBR or MBB:
|
This feature requires Teradata 13.00 or later and the three-dimensional functions (as specified in the above table) require Teradata 15.00 or later.