Re: Array shift equivalent?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Array shift equivalent?
Date: 2006-12-06 15:26:40
Message-ID: 26117.1165418800@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Glaesemann <grzm(at)seespotcode(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2006-12-06 15:29:36 Re: Time Stamp auto Field
Previous Message Michael Glaesemann 2006-12-06 14:58:06 Array shift equivalent?