Re: Arrays

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