Re: Array shift equivalent? - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Array shift equivalent?
Date
Msg-id CC2BA225-8E3C-473F-9006-B3A0E0B3D252@seespotcode.net
Whole thread Raw
In response to Re: Array shift equivalent?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Wei Weng
Date:
Subject: Re: Anything I can do to speed up this query?
Next
From: Curtis Braly
Date:
Subject: Problems connecting to server