Search Postgresql Archives

Re: Howto determin the number of elemnts of an array

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




contrib/intarray

On Mon, 31 Jan 2005 20:00:06 +0100, Együd Csaba <csegyud@xxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxx]
Sent: Monday, January 31, 2005 5:16 PM
To: Együd Csaba; 'Sven Willenberger'; pgsql-general@xxxxxxxxxxxxxx
Subject: Re:  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@xxxxxxx]
Sent: Monday, January 31, 2005 4:27 PM
To: pgsql-general@xxxxxxxxxxxxxx
Cc: Együd Csaba
Subject: Re:  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






---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux