16.20 - Sample Query - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)

Consider the following metric_distance table that has a meter column and distance table that has a foot column:

CREATE TABLE metric_distance(pkey INTEGER, meters meter);
CREATE TABLE distance(pkey INTEGER, feet foot)

The following statement shows when Teradata Database uses the meter_toFoot cast method in a query that requires implicit conversion from meter to foot:

INSERT INTO distance
   SELECT * FROM metric_distance;