Re: Arrays: determining size

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: Arrays: determining size
Дата
Msg-id 3DEBCA0F.20106@joeconway.com
обсуждение исходный текст
Ответ на Re: Arrays: determining size  (Steve Crawford <scrawford@pinpointresearch.com>)
Ответы Re: Arrays: determining size  (Steve Crawford <scrawford@pinpointresearch.com>)
Список pgsql-general
Steve Crawford wrote:
> Thanks - I had read that document but overlooked array_dims (I had looked for
> such functions using \df in psql but array_dims isn't listed). The values
> returned are not two-dimensional but rather a start:end element of an array
> (see notes below).
>
> Ideally I'd like to get a single int that is the size of the array rather
> than the min and max element of the array that array_dims returns but I don't
> see a built-in function that does that.

FWIW, in cvs (7.4devel) there are array_lower() and array_upper() functions,
which return ints. Unfortunately they didn't make it into 7.3.

Joe


В списке pgsql-general по дате отправления:

Предыдущее
От: Medi Montaseri
Дата:
Сообщение: Re: Segmentation fault while COPY in 7.3
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: [SQL] CURRENT_TIMSTAMP