Re: Array shift equivalent?

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: Array shift equivalent?
Дата
Msg-id CC2BA225-8E3C-473F-9006-B3A0E0B3D252@seespotcode.net
обсуждение исходный текст
Ответ на Re: Array shift equivalent?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Dec 7, 2006, at 0:26 , Tom Lane wrote:

> Michael Glaesemann <grzm@seespotcode.net> writes:
>> I'm trying to shift the first element off of an array, but I'm just
>> not getting it. I'm not necessarily interested in saving the rest of
>> the array. i just want to get the first element, which in this case
>> is another array.
>
> No, it isn't.  What you've got is a 2-D array.  I don't think there
> is an operation that will produce a 1-D subset --- the array slice
> subscript operation produces something that's smaller but still has
> the same number of dimensions.

Thanks for the explanation and confirmation. I end up iterating over
the elements of the subarray, so I worked around it by iterating over
this_array[1][i].

Michael Glaesemann
grzm seespotcode net



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

Предыдущее
От: Wei Weng
Дата:
Сообщение: Re: Anything I can do to speed up this query?
Следующее
От: Curtis Braly
Дата:
Сообщение: Problems connecting to server