nullCompare

swordfish.function.nullCompare()

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.

Parameters:

• func (Constant) – The operator <, >, >=, <=, or the function between, in.

• X (Constant) – Can be a scalar, pair, vector, matrix, or set.

• Y (Constant) –

  Can be a scalar, pair, vector, matrix, or set.

  Note

  X and Y do not support the following data types currently: STRING, SYMBOL, IPADDR, UUID, BLOB, INT128.