Select from arrays in a way similar to IN
You can use overlap (&amp;&amp;) operator which means "have elements in common". 

SELECT
    name
  FROM sal_emp
  WHERE
    pay_by_quarter &amp;&amp; ARRAY[1,4,5]


Documentation link is here: Array Operators