15.10 - Chapter 10 Embedded Services System Functions - Teradata Database

Teradata Database SQL Geospatial Types

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1181-151K

This chapter describes the Teradata Database geospatial embedded services system functions.

For best performance, when a geospatial system function exists that performs the same functionality as a geospatial UDF, use the system function.

If your SQL statement specifies the name of a geospatial system function that is also the name of a geospatial UDF, Teradata Database calls the system function. To call the UDF, qualify the name of the UDF with the SYSSPATIAL database name.

The data type of an argument that you pass to a geospatial system function does not need to exactly match the corresponding declared argument type as described in the function description. If the argument type is a compatible type, as listed in the following table, Teradata Database tries to implicitly cast the argument.

 

Declared Argument Type

Compatible Argument Types

DECIMAL

BYTEINT, SMALLINT, INTEGER, or BIGINT

FLOAT

BYTEINT, SMALLINT, INTEGER, BIGINT, DECIMAL, or NUMERIC

INTEGER

BYTEINT or SMALLINT

VARCHAR

CHAR

To pass an argument where the data type is not an exact match and is not a compatible type according to the preceding table, you must explicitly convert the argument.