Re: array size

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 <dmitigr(at)gmail(dot)com> wrote:

> Hey,
>
> 2011/2/24 akp geek <akpgeek(at)gmail(dot)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.
>
>
>