Re: Howto determin the number of elemnts of an array

contrib/intarray

On Mon, 31 Jan 2005 20:00:06 +0100, Együd Csaba <csegyud(at)vnet(dot)hu> wrote:

> Hi,
> this function is part of GiST which is not installed on my server.
> Should I
> install the whole GiST or there is a single package to implement only
> this
> feature?
>
> thank you,
> -- Csaba
>
> -----Original Message-----
> From: PFC [mailto:lists(at)boutiquenumerique(dot)com]
> Sent: Monday, January 31, 2005 5:16 PM
> To: Együd Csaba; 'Sven Willenberger'; pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Howto determin the number of elemnts of an array
>
>
> icount( array )
>
>
>> Hi Seven,
>> it would be better for me if it returned the number of elements as an
>> integer even if the array is empty (in this case it returns with NULL).
>> No
>> metter this is easily can be worked around, but it would have been
>> more confortable.
>>
>> Thank you very much.
>> -- Csaba Együd
>>
>> -----Original Message-----
>> From: Sven Willenberger [mailto:sven(at)dmv(dot)com]
>> Sent: Monday, January 31, 2005 4:27 PM
>> To: pgsql-general(at)postgresql(dot)org
>> Cc: Együd Csaba
>> Subject: Re: [GENERAL] Howto determin the number of elemnts of an
>> array
>>
>>
>>
>> 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
>>
>
>