Re: Howto determin the number of elemnts of an array

From: Sven Willenberger <sven(at)dmv(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Együd Csaba <csegyud(at)vnet(dot)hu>
Subject: Re: Howto determin the number of elemnts of an array
Date: 2005-01-31 15:27:15
Message-ID: 41FE4E53.6040308@dmv.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Együd Csaba wrote:
> Hi,
> how can I determin the number of elements of an array? I saw function
> array_dims() which returns a string value representing the dimensions of the
> array. Is there a function which returns only the number of elements as an
> integer.
>
> -- Csaba
>

array_upper(arrayname,dimension) will return the number of elements in
the specified dimension of array arrayname.

Sven

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2005-01-31 15:28:24 Re: postgres session termination
Previous Message Marian POPESCU 2005-01-31 14:22:39 "Invalid multibyte character for locale" still there