Postgres select rows where ANY in a given array = ANY in column array

Question

In Postgres, I need to select all rows where any value in an array (passed as variable) is equal to any value in the column (that is also an array). This means something like this:

SELECT * 
from table 
where ANY (value_in_an_array_variable) = ANY (value_in_a_column_array);

If there is no direct way what's the best alternative?

user330315 · Accepted Answer · 2017-09-19 09:55:20Z

4

You are looking for the overlaps ("have elements in common") operator:

select *
from some_table
where array_column && array[1,2,3];

answered Sep 19, 2017 at 9:55

user330315

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

Collectives™ on Stack Overflow

Postgres select rows where ANY in a given array = ANY in column array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related