MBR Transforms | Geospatial Data Types | Teradata Vantage - 17.05 - Transforms - Teradata Database

Teradata Vantageā„¢ - Geospatial Data Types

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1181-170K

Client applications can use a VARCHAR to insert a value into an MBR column. The VARCHAR must have the following format:

(xmin, ymin, xmax, ymax)

where white space can appear anywhere.

For queries that select data from an MBR column, the database returns the MBR data as a VARCHAR(256) using the same format (xmin, ymin, xmax, ymax).

Consider the following definition of a table that defines an MBR column.

CREATE TABLE sample_MBRs (skey INTEGER, shape_mbr MBR);

A query that selects data from the shape_mbr column results in the database returning the column data as a VARCHAR(256):

SELECT *
FROM sample_MBRs;

SKEY          SHAPE_MBR
--------      -------------
1001          (10, 3, 22, 7)