Thread: Howto determin the number of elemnts of an array
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 -- 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.
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
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.
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
>
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.
contrib/intarray
On Mon, 31 Jan 2005 20:00:06 +0100, Együd Csaba <csegyud@vnet.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@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
>>
>
>
I really can't find such file in contrib dir. Nor files containing 'icount' pattern. Sorry. I use Pg8.0 final on windows XP. On the http://www.sai.msu.su/~megera/postgres/gist/ url I can find only a patch. Where can I download the whole package from? Thank you. -- Csaba -----Original Message----- From: PFC [mailto:lists@boutiquenumerique.com] Sent: Monday, January 31, 2005 8:48 PM To: Együd Csaba; 'Sven Willenberger'; pgsql-general@postgresql.org Subject: Re: [GENERAL] Howto determin the number of elemnts of an array contrib/intarray On Mon, 31 Jan 2005 20:00:06 +0100, Együd Csaba <csegyud@vnet.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@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.