SQL UDF Return JSON Type Example | VantageCloud Lake - Example: SQL UDF with RETURN Clause - Teradata VantageCloud Lake

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]'));