title: postgresql: select array
body: <p>I've a table that looks like:</p>
  
  <pre><code> id |   t   
  ----+-------
    1 | {1,2}
    2 | {5,2}
    3 | {6,2}
    4 | {1,7}
    5 | {1,8}
    6 | {1,9}
  </code></pre>
  
  <p>I'm looking for a SELECT query that will return me array of <code>t</code> like <code>{{1,2}, {5,2}, ... {1,9}}</code>.  </p>
  
  <p>Had <code>t</code> not been an array data type, it would have been easy like:</p>
  
  <pre><code>SELECT ARRAY (SELECT t from tbl_foo);
  </code></pre>
  
  <p>Can same be done if data type is <code>int[]</code>?</p>