title: Finding array length in postgres
body: <p>I tried <code>array_upper(array(Value))</code>   and <code>array_upper((Value):array[])</code>  but was getting syntax error. </p>
  
  <p>Value : data type is int [];
  I am expecting the result as below table:</p>
  
  <pre><code> Pname  week_date      Value    array_length
      5773    6/8/2013    {29}            1
      5773    3/30/2013   {27}            1
      5773    3/16/2013   {138,3,4}       3
      5773    3/9/2013    {37,8}          2
      5773    1/19/2013   {66}            1
      5773    1/5/2013    {49,50,50,56}   4
  </code></pre>
  
  <p>But this works fine </p>
  
  <pre><code>select array_upper(array[1,2,3,6], 1)
  </code></pre>
  
  <p>I need to use Value column and find out the length of that value array</p>
  
  <p>postgres version : 8.2 </p>