Closed
Description
Is your feature request related to a problem or challenge?
Summary
Characteristic | Description |
---|---|
Function name: | array_has_all |
Aliases: | list_has_all , @> , <@ |
Original function?: | No |
Function Description: | Clickhouse: Checks whether one array is a subset of another. DuckDB: Returns true if all elements of sub-list exist in list. |
Sources: | Concept ClickHouse DuckDB |
Examples:
select array_has_all([1, 2, 3, 4], [3, 4]);
----
true
select array_has_all([1, 2, 3, 4], [5, 4]);
----
false
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
#6972
No response