ne

Description

Return true if A is not equal to B.

Return type

bool

Domain

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

Categories

Usage

ne(a, b)

Argument

Type

Optional

Repeatable

Restrictions

a

comparable

no

no

none

b

comparable

no

no

none

Examples

make_col foo:ne(bar, baz)

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