Comparison Functions¶
- between(x, min, max) boolean ¶
Returns true if x is within the specified [min, max] range inclusive. Supports TINYINT, SMALLINT, INTEGER, BIGINT, DOUBLE, REAL, VARCHAR, DATE types. The types of all arguments must be the same.
- distinct_from(x, y) boolean ¶
In SQL a
NULL
value signifies an unknown value, so any comparison involving aNULL
will produce NULL. Thedistinct_from
treats NULL as a known value and guarantees either atrue
orfalse
outcome even in the presence ofNULL
input. Sodistinct_from(NULL, NULL)
returnsfalse
, since aNULL
value is not considered distinct fromNULL
.
- eq(x, y) boolean ¶
Returns true if x is equal to y. Supports all scalar types. The types of x and y must be the same.
- greatest(value1, value2, ..., valueN) [same as input] ¶
Returns the largest of the provided values. Supports DOUBLE, BIGINT, VARCHAR, TIMESTAMP, DATE input types. The types of all arguments must be the same.
- gt(x, y) boolean ¶
Returns true if x is greater than y. Supports all scalar types. The types of x and y must be the same.
- gte(x, y) boolean ¶
Returns true if x is greater than or equal to y. Supports all scalar types. The types of x and y must be the same.
- is_null(x) boolean ¶
Returns true if x is a null. Supports all types.
- least(value1, value2, ..., valueN) [same as input] ¶
Returns the smallest of the provided values. Supports DOUBLE, BIGINT, VARCHAR, TIMESTAMP, DATE input types. The types of all arguments must be the same.
- lt(x, y) boolean ¶
Returns true if x is less than y. Supports all scalar types. The types of x and y must be the same.
- lte(x, y) boolean ¶
Returns true if x is less than or equal to y. Supports all scalar types. The types of x and y must be the same.
- neq(x, y) boolean ¶
Returns true if x is not equal to y. Supports all scalar types. The types of x and y must be the same.