eq¶
Description¶
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.
Return type¶
bool
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
eq(a, b)
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
a |
storable |
no |
no |
none |
b |
storable |
no |
no |
none |
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.