in(item: storable, [choice: item]+) -> bool

Returns true when the first expression equals at least one of the following expressions, all of which must be the same type class as the first (after the usual compatibility checks). At least one candidate value is required after the item expression. Very large lists can hit the engine’s maximum number of expressions in a single list. Null behavior follows ordinary boolean disjunction semantics: a null item compared only to non-null constants yields false, while a null among nulls or mixed null and non-null branches can yield null, consistent with SQL-style IN.

Domain

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

Categories

• Boolean

Examples

filter in(status, "ok", "warn", "info")

Retains rows whose status string equals any of the three listed literals.

filter in(string(priority), "0", "1", "2")

Casts a numeric priority to string and tests membership in a small string whitelist.