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 wrote:
> Hey,
>
> 2011/2/24 akp geek
>
> Hi all -
>>
>> I am trying to find the number of elements in the array.
>> Right now I am usi
Hey,
2011/2/24 akp geek
> 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(
It may help to specify why you feel that array_upper and array_lower are
insufficient for your use. I mean, you could " count( unnest( array ) ) "
but whether that is better or worse than array_upper really depends on your
needs.
David J.
From: pgsql-general-ow...@postgresql.org
[mailto:pg
