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  (Együd Csaba <csegyud@vnet.hu>)
Список 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 по дате отправления:

Предыдущее
От: Abdul-Wahid Paterson
Дата:
Сообщение: Re: Postgresql and Athlon64 ?
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Extended unit