Re: Arrays

Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> · Wed, 14 Sep 2011 11:15:07 -0700



    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