SQL UDF Return JSON Type Example | JSON Data Type | Teradata Vantage - Example: SQL UDF with RETURN clause - Advanced SQL Engine - Teradata Database

This example shows an SQL UDF with a RETURN expression that evaluates to JSON type.

CREATE FUNCTION New_Funct ()
 RETURNS JSON(100)
 LANGUAGE SQL
CONTAINS SQL
DETERMINISTIC
SPECIFIC New_Funct
SQL SECURITY DEFINER
COLLATION INVOKER
INLINE TYPE 1
 RETURN (new JSON('[1,2,3]'));