v.18.4New Feature

has function enhancement: supports searching numeric values in Enum arrays

Official CH changelog text
The has function now allows searching for a numeric value in an array of Enum values Maxim Khrisanfov.
The has function now supports searching for a numeric value within an array of Enum values.

Why it matters

This feature allows users to efficiently check for the presence of numeric representations of Enum values in arrays, improving flexibility and usability when working with Enum data types.

How to use it

Use the has function as usual with an array of Enum values and provide the numeric value to search for. For example:

SELECT has(enum_array_column, 1) FROM table;

Related resources

PreviousNext