nullCompare

nullCompare(func, X, Y)

func is the operator <, >, >=, <=, or the function between, in.

X and Y can be scalars, pairs, vectors, matrices, or sets. If both X and Y are vectors or matrices, they must be of the same length or dimension.

Return a Boolean value which is the result of func(X,Y). Return NULL if the calculation involves NULL values. This function is not affected by the configuration paramter nullAsMinValueForComparison.

When nullAsMinValueForComparison=true, a NULL value is treated as the minimum value in data comparison. Function nullCompare, however, returns NULL values, which is not affected by the configuration paramter nullAsMinValueForComparison.

NULL < 3
# output
true

nullCompare(<, NULL, 3)
# output
NULL

m1=matrix(1 2 NULL, NULL 8 4, 4 7 2 )
m2 = 1..9$3:3
m1>m2

nullCompare(>,m1,m2)

nullCompare(between, 4 5 NULL, 4:9)
# output
[1,1,]