Repository navigation
Implement array_has_any function #6976
Description
Is your feature request related to a problem or challenge?
Summary
| Characteristic | Description |
|---|---|
| Function name: | array_has_any |
| Aliases: | list_has_any |
| Original function?: | No |
| Function Description: | PostgreSQL: Do the arrays overlap, that is, have any elements in common? Azure DataBricks: Returns true if the intersection of array1 and array2 is not empty. Clickhouse: Checks whether two arrays have intersection by some elements. DuckDB: Returns true if any elements exist is both lists. |
| Sources: | Concept PostgreSQL Azure ClickHouse DuckDB |
Examples:
select has_any([1, 2, 3, 4], [3, 5, 6]);
----
true
select has_any([1, 5, 3, 4], [2, 6]);
----
false
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
No response
Activity