Purpose
Takes grouped sets of relational data, makes a pass over each group, and returns one result for the group.
Syntax
udf_name ( [ argument [,...] ] )
For UDFs that are defined with parameters of TD_ANYTYPE data type:
( udf_name { () RETURNS { data_type | STYLE column_expr } | ( argument [,...] ) [ RETURNS { data_type | STYLE column_expr } ] } )
- udf_name
- The name of the aggregate UDF.
- argument
- A valid SQL expression. See Usage Notes for rules that apply to aggregate UDF arguments.
- data_type
- The desired return type of the TD_ANYTYPE result parameter.
- column_expr
- A table or a view column reference that determines the return type of the TD_ANYTYPE result parameter.