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