Unfortunately the our database is still 8.3. that's a limitation for using array_length
Regards On Thu, Feb 24, 2011 at 4:08 PM, Dmitriy Igrishin <dmit...@gmail.com> wrote: > Hey, > > 2011/2/24 akp geek <akpg...@gmail.com> > > Hi all - >> >> I am trying to find the number of elements in the array. >> Right now I am using array_upper and array_lower. Is there any other way of >> getting the number of elements? >> > You may use array_length() function, e.g. > dmitigr=> SELECT array_length(ARRAY[ARRAY[1,2,3],ARRAY[4,5,6]], 1); > array_length > -------------- > 2 > (1 row) > > dmitigr=> SELECT array_length(ARRAY[ARRAY[1,2,3],ARRAY[4,5,6]], 2); > array_length > -------------- > 3 > (1 row) > > See http://www.postgresql.org/docs/9.0/static/functions-array.html > >> >> thanks for the help >> >> Regards >> > > > > -- > // Dmitriy. > > >