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

From Együd Csaba
Subject Re: Howto determin the number of elemnts of an array
Date
Msg-id 0IB7007OA3N4B7@mail.vnet.hu
Whole thread Raw
In response to Re: Howto determin the number of elemnts of an array  (PFC <lists@boutiquenumerique.com>)
Responses Re: Howto determin the number of elemnts of an array
List pgsql-general
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@boutiquenumerique.com]
Sent: Monday, January 31, 2005 5:16 PM
To: Együd Csaba; 'Sven Willenberger'; pgsql-general@postgresql.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@dmv.com]
> Sent: Monday, January 31, 2005 4:27 PM
> To: pgsql-general@postgresql.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
>


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.8.2 - Release Date: 2005.01.28.



pgsql-general by date:

Previous
From: Shawn Harrison
Date:
Subject: Re: Allowing update of column only from trigger
Next
From: Tom Lane
Date:
Subject: Re: Dereferencing a 2-dimensional array in plpgsql