15.10 - RETURNS NULL ON NULL INPUT - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)
Last Update
2018-06-05

If any parameters are null at the time the function is to be called, a null result is returned without evaluating the function.

You cannot specify this option for aggregate functions.

This clause is optional and can only be specified once per function definition.

The default is CALLED ON NULL INPUT.