16.20 - Transforms - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ Geospatial Data Types

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1181-162K
Language
English (United States)

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, Teradata 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 Teradata Database returning the column data as a VARCHAR(256):

   SELECT *
   FROM sample_MBRs;

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