ne(a: storable, b: storable) -> bool

Returns true when both storable operands are non-null and not equal after the compiler's allowed coercions, and false when they are non-null and equal. If either operand is null, the result is null bool, matching three-valued logic alongside eq. The operand representation types must be comparable (each must be a subtype of the other after coercion).

Domain

This is a scalar function (calculates a single output value for a single input row).

Categories

• Boolean

Examples

filter ne(environment, "production")

Keeps rows whose environment value is not the literal "production" using ne().

make_col differs_or_unknown:ne(old_hash, new_hash)

Shows ne() with nullable hashes, yielding null bool when either side is null instead of true.