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

From Tom Lane
Subject Re: Array shift equivalent?
Date
Msg-id 26117.1165418800@sss.pgh.pa.us
Whole thread Raw
In response to Array shift equivalent?  (Michael Glaesemann <grzm@seespotcode.net>)
Responses Re: Array shift equivalent?  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-general
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.

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Array shift equivalent?
Next
From: Bruno Wolff III
Date:
Subject: Re: Time Stamp auto Field