maxIgnoreNull

swordfish.function.maxIgnoreNull()

A binary scalar function that returns the maximum by comparing X with Y.

Difference between max and maxIgnoreNull:

• max: Null values are treated as the minimum value if nullAsMinValueForComparison=true, otherwise comparison involving null values returns NULL.

• maxIgnoreNull: Null values are ignored in comparison and non-null maximum is returned. If both elements in X and Y are null, NULL is returned. This function is not affected by configuration parameter nullAsMinValueForComparison.

Parameters:

• X (Constant) – A numeric, LITERAL or TEMPORAL scalar, pair, vector or matrix.

• Y (Constant) – A numeric, LITERAL or TEMPORAL scalar, pair, vector or matrix.