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: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 there any other way of
getting the number of elements?

 

thanks for the help

 

Regards

Reply via email to