17.10 - Sample Query - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
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 Vantage uses the meter_toFoot cast method in a query that requires implicit conversion from meter to foot:

INSERT INTO distance
   SELECT * FROM metric_distance;