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.
>
>
>

Reply via email to