16.20 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Advanced SQL Engine
Teradata Database
Release Number
April 2020
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

When Teradata Database evaluates an aggregate UDF expression, it invokes the aggregate function once for each item in an aggregation group, passing the detail values of a group through the input arguments. To accumulate summary information, the context is retained each time the aggregate function is called.

The rules that apply to the arguments in an aggregate function call are the same as those that apply to a scalar function call. See UDF Arguments.

The result type of an aggregate UDF is based on the return type specified in the RETURNS clause of the CREATE FUNCTION statement. If the result parameter is of TD_ANYTYPE data type, see Result Data Type for information on how the return type is determined.

The default title of an aggregate UDF appears as: