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 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
