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

Return true if A is equal to B. The function follows ternary logic and returns null if any of its inputs is null. To compare values that can potentially be null, consider using the same function.

Domain

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

Categories

• Boolean

Examples

make_col foo:eq(bar, baz)

This produces a column named foo comparing bar and and baz. If bar is 1 and baz is 1, foo is true. If bar is 1 and baz is 0, foo is false. If bar is 1 and baz is null, foo is null.