| From: | "David Johnston" <polobo(at)yahoo(dot)com> |
|---|---|
| To: | "'akp geek'" <akpgeek(at)gmail(dot)com>, "'pgsql-general'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: array size |
| Date: | 2011-02-24 19:33:19 |
| Message-ID: | 009901cbd459$b18b8600$14a29200$@yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2011-02-24 19:46:48 | Re: database is bigger after dump/restore - why? (60 GB to 109 GB) |
| Previous Message | akp geek | 2011-02-24 19:17:13 | array size |