Re: array_dims array_lower/upper distance

Поиск
Список
Период
Сортировка
Искать
От
Greg Stark
Тема
Re: array_dims array_lower/upper distance
Дата
Msg-id
87zmq5kq8h.fsf@stark.xeocode.com
Ответ на
Список
Дерево обсуждения
array_dims array_lower/upper distance Matthew Peter <survivedsushi@yahoo.com>
Re: array_dims array_lower/upper distance Tony Wasson <ajwasson@gmail.com>
Re: array_dims array_lower/upper distance Guy Fraser <guy@incentre.net>
Re: array_dims array_lower/upper distance Greg Stark <gsstark@mit.edu>
Re: array_dims array_lower/upper distance Guy Fraser <guy@incentre.net>
Re: array_dims array_lower/upper distance Bruno Wolff III <bruno@wolff.to>
Re: array_dims array_lower/upper distance Guy Fraser <guy@incentre.net>
Re: array_dims array_lower/upper distance Matthew Peter <survivedsushi@yahoo.com>
Re: array_dims array_lower/upper distance Guy Fraser <guy@incentre.net>
Re: array_dims array_lower/upper distance Matthew Peter <survivedsushi@yahoo.com>
Guy Fraser  writes:

> So to answer his question he would likely want :
> 
> SELECT
>  array_upper(item,1) - array_upper(item,0) + 1 as elements
> FROM
>  arraytest ;

Note that this doesn't work for empty arrays. 
It will return NULL instead of 0.


-- 
greg
В списке pgsql-general по дате отправления
От: Tony Wasson
Дата:
От: Rafael Martinez
Дата:
Сообщение: Lines of code in PG 8.0 & 8.1?
FAQ