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 > -- 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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
