title: Postgresql - Array_remove for elements from select
body: <p>I have a column (members) with an array that has a varying number of elements.</p>
  
  <p>e.g.</p>
  
  <pre><code>id   members (integer[])
  1    {1, 3, 5, 7}
  2    {4, 5, 7, 9}
  </code></pre>
  
  <p>I have a table (unwanted_members) with members that I want removed if they exist, e.g.</p>
  
  <pre><code>member
  1
  7
  </code></pre>
  
  <p>I want to remove these members from the arrays, i.e.</p>
  
  <pre><code>id  members
  1   {3, 5}
  2   {4, 5, 9}
  </code></pre>
  
  <p>Can anyone suggest a simple methodology?</p>