| From: | Steve Crawford <scrawford(at)pinpointresearch(dot)com> |
|---|---|
| To: | Bob Pawley <rjpawley(at)shaw(dot)ca> |
| Cc: | Postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Arrays |
| Date: | 2011-09-14 18:15:07 |
| Message-ID: | 4E70EF2B.7000507@pinpointresearch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 09/14/2011 11:01 AM, Bob Pawley wrote:
> Hi
> Is there a method of counting the number of elements in an array??
> Bob
Look at array_dims, array_upper and array_lower.
But note that PostgreSQL allows multi-dimensional arrays. The array_dims
function gives you all the dimensions. If you have a one-dimensional
array you can use array_upper(yourarray, 1) and array_lower(yourarray, 2).
Also be aware that the first element in a PostgreSQL array typically has
an index of 1 but does not have to. In fact it is legal to have arrays
that start at a negative index and proceed to a positive one.
Cheers,
Steve
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Antonio Vieiro | 2011-09-14 18:33:44 | Re: Bit datatype performance? |
| Previous Message | Merlin Moncure | 2011-09-14 18:13:47 | Re: Identifying Reason for Column Name Returned by SELECT |