title: How to get an array size (and the biggest) with an SQL statement?
body: <p>I am using postgres and some of my table's field are arrays.
  I am looking for the biggest array is there any way to find this info with a SQL statement ?</p>
  
  <pre><code>CREATE TABLE chapter
  (....
  chapter_path integer[],
  .....)
  </code></pre>
  
  <p>My chapter path are like that <code>{x,y,z} {x,y} {x}</code></p>
  
  <p>How with a SQL statement can I get <strong>3</strong> corresponding to <code>{x,y,z}</code> integer array size ?</p>