title: PostgreSQL check if array contains any element from left-hand array
body: <p>I know that in PostgreSQL you can run a query like:</p>
  
  <p><code>SELECT (1 = ANY('{1,3,4,7}'::int[])) AS result</code> to check if the right-hand array contains the element <code>1</code>. I was wondering if there is an easy way to check if the right-hand array contains any element from the <em>left-hand</em> array. Something like:</p>
  
  <p><code>SELECT ('{2,3}'::int[] = ANY('{1,3,4,7}'::int[])) AS result</code></p>
  
  <p>Is there an easy way to do this without iterating over the left-hand loop myself?</p>