title: Postgres array lookup in WHERE clause
body: <p>I have a query:</p>
  
  <pre><code>SELECT bar, (SELECT name FROM names WHERE value = bar) as name
  FROM foobar WHERE foo = 1 and bar = ANY (1,2,3)
  </code></pre>
  
  <p>My problem is, when there is no row containing <code>bar = 3</code> (or whatever other value is requested) in table <code>foobar</code>, no rows are returned for that value of bar. </p>
  
  <p>I'd like my query to return a row of <code>[bar, NULL]</code> instead, but can't think up a way to approach this.</p>
  
  <p>Is this even possible?</p>