minIgnoreNull

swordfish.function.minIgnoreNull()

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

Difference between min and minIgnoreNull:

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

• minIgnoreNull: Null values are ignored in comparison and non-null minimum 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.