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(
gresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of akp geek
Sent: Thursday, February 24, 2011 2:17 PM
To: pgsql-general
Subject: [GENERAL] array size
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
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?
thanks for the help
Regards
