Postgres Pro
Downloads
Home   >   mailing lists

Re: Howto determin the number of elemnts of an array - Mailing list pgsql-general

From Sven Willenberger
Subject Re: Howto determin the number of elemnts of an array
Date
Msg-id 41FE4E53.6040308@dmv.com
Whole thread Raw
In response to Howto determin the number of elemnts of an array  (Együd Csaba <csegyud@vnet.hu>)
Responses Re: Howto determin the number of elemnts of an array  (Együd Csaba <csegyud@vnet.hu>)
List pgsql-general
Tree view 

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

pgsql-general by date:

Previous
From: Steve Wampler
Date:
Subject: pg_dump in 7.2.4 with trigger functions
Next
From: Alban Hertroys
Date:
Subject: Re: postgres session termination