title: Postgres - Function to return the intersection of 2 ARRAYs?
body: <p>In postgresql, you can use the &amp;&amp; operator to return t (true) if two arrays have common members, i.e. they overlap. Is there a function/operator that will return what those common members are?</p>
  
  <p>i.e. something like this</p>
  
  <pre><code>select arrray_intersection(ARRAY[1, 4, 2], ARRAY[2, 3]);
  ARRAY[2]
  </code></pre>