title: Postgres - join on array values
body: <p>Say I have a table with schema as follows</p>
  
  <pre><code>id  |  name  |   tags   |
  1   |  xyz   |  [4, 5]  |
  </code></pre>
  
  <p>Where tags is an array of references to ids in another table called tags.</p>
  
  <p>Is it possible to join these tags onto the row? i.e. replacing the id numbers with the values for thise rows in the tags table such as:</p>
  
  <pre><code>id  |  name  |                        tags                        |
  1   |  xyz   | [[tag_name, description], [tag_name, description]] |
  </code></pre>
  
  <p>If not, I wonder if this an issue with the design of the schema?</p>