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

Returns true when the first argument is strictly greater than the second, after the compiler applies numeric promotion and other coercion between the two operands when possible. Both arguments use storable scalar types that must be mutually comparable (for example two numbers, two strings, two booleans, two durations, or two timestamps); mixing unrelated types is rejected. If either operand is null, the result is null, unlike same, which can return true when both sides are null.

Domain

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

Categories

• Boolean

Examples

filter gt(status_code, 400)

Keeps rows whose numeric HTTP status code is strictly greater than 400.