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.