MBB Casts | Geospatial Data Types | Teradata Vantage - 17.10 - Casts - 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)

Vantage implements cast functionality that allows data type conversions between VARCHAR and MBB types. To convert a VARCHAR type to an MBB type, the VARCHAR must use the following format:

(xmin, ymin, zmin, xmax, ymax, zmax)

where white space can appear anywhere.

Consider the following table definitions.

CREATE TABLE sample_MBBs (skey INTEGER, shape_mbb MBB);
CREATE TABLE sample_data (mbb_data VARCHAR(340));

This example performs MBR to VARCHAR data type conversion:

INSERT INTO sample_data
SELECT CAST(shape_mbb as VARCHAR(340))
FROM sample_MBBs;