Example: Creating a Function with Geospatial Input Arguments - Analytics Database - Teradata Vantage

SQL Data Definition Language Syntax and Examples

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-10-04
dita:mapPath
jco1628111346878.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
mdr1472255012272
lifecycle
latest
Product Category
Teradata Vantage™

The following CREATE FUNCTION request has input parameters of the ST_GEOMETRY type, specifies the method st_within in its RETURN statement, and returns an INTEGER value from the invocation of st_within.

     CREATE FUNCTION test.geospatial_type_udf 
       (a ST_GEOMETRY, b ST_GEOMETRY)
     RETURNS INTEGER
     LANGUAGE SQL
     DETERMINISTIC
     CONTAINS SQL
     SPECIFIC test.geospatial_type_UDF
     CALLED ON NULL INPUT
     SQL SECURITY DEFINER
     COLLATION INVOKER
     INLINE TYPE 1
     RETURN a.st_within(b);