Postgres array contains any from another array?

Question

I am looking to perform a query that returns a row if the array column type contains at least one entry from another array, so example:

Row1

col_a = {1,2}

I want to a query that says col_a contains {3,1} and it should return Row1 because col_a contains '1'.

The value {3,1} in the example will come from another subquery. I am not sure this is possible, and I am struggling to find an example. The closest I found was the @> operator but that requires all entries to be in col_a right rather than any matching?

JGH · Accepted Answer · 2021-05-25 15:13:36Z

9

You can use the && (overlap) operator

select array[1,2,3,4] && array[3,9];
 ?column?
----------
 t
(1 row)

answered May 25, 2021 at 15:13

JGH

18.2k5 gold badges40 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

iQ. Over a year ago

Fantastic I missed this operator thank you

Collectives™ on Stack Overflow

Postgres array contains any from another array?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related