Intersection Operator (&&)

with nums as (
    SELECT GENERATE_SERIES(1, 5) AS num
)

select ARRAY [6,7,8] && (
        select ARRAY_AGG(num)
        from nums
    )

with nums as (
    SELECT GENERATE_SERIES(1, 5) AS num
)

select ARRAY [1,2,3] && (
        select ARRAY_AGG(num)
        from nums
    )

---

Last update: 2023-04-24