title: How can I match the items in an array column, with a different table in Postgres?
body: <p>I have a table that has an array column with a bunch of dog breed guids.  I want to lookup these values and basically return the lookup values instead of the guids.</p>
  <pre><code>CREATE TABLE dogs(
   name text,
   breeds text[]
  );
  
  INSERT INTO dogs (name, breeds) VALUES ('Barkley', '{&quot;abc&quot;, &quot;xyz&quot;}');
  INSERT INTO dogs (name, breeds) VALUES ('Ponyo', '{&quot;zzz&quot;, &quot;xyz&quot;}');
  
  CREATE TABLE breeds(
   guid text,
   breed text
  );
  
  
  INSERT INTO breeds (guid, breed) VALUES ('abc', 'Maltipoo');
  INSERT INTO breeds (guid, breed) VALUES ('xyz', 'Jack Russel');
  INSERT INTO breeds (guid, breed) VALUES ('zzz', 'Dalmatian');
  </code></pre>
  <p>I would like to be able to return the following:</p>
  <pre><code>Barkley, ['Maltipoo', 'Jack Russel']
  Ponyo, ['Jack Russel', 'Dalmatian']
  </code></pre>
  <p>Essentially, look them up in my 'breeds' table before returning the values.</p>