Re: Howto determin the number of elemnts of an array
От | PFC |
---|---|
Тема | Re: Howto determin the number of elemnts of an array |
Дата | |
Msg-id | opslg55el9th1vuj@musicbox обсуждение исходный текст |
Ответ на | Re: Howto determin the number of elemnts of an array (Együd Csaba <csegyud@vnet.hu>) |
Ответы |
Re: Howto determin the number of elemnts of an array
|
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: