title: Select all rows where array contains values from a given list in Postgres
body: <p>I have a table with an integer array column. I want to select all rows where contains at least one int value from a given list.</p>
  
  <p>E.g.</p>
  
  <pre><code>SELECT * FROM table where (111) = ANY (columarray)
  </code></pre>
  
  <p>returns all rows where columnarray contains 111.</p>
  
  <p>Now I want select all rows where columnarray contains 111 or/and 222. Something like</p>
  
  <pre><code>SELECT * FROM table where (111,222) = ANY (columnarray)
  </code></pre>
  
  <p>that doesnt work. It returns an error</p>
  
  <blockquote>
    <p>Error: ERROR: operator does not exist: record = integer
      Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
      Position: 45
    SQLState:  42883
    ErrorCode: 0</p>
  </blockquote>