Array containment operator #6884
Description
Is your feature request related to a problem or challenge?
Like other popular databases (DuckDB, PostgreSQL) it would be better to support some operators for working with arrays, making life easier for the user. The most popular operator is array containment operator which check a subset belongs to a set (in other words, the operator is alias of array_has_all function).
There are two options:
-
@>(equals toarray_has_all(array1, array2) -
<@(equals toarray_has_all(array2, array1)
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response