Re: array_reverse() - Mailing list pgsql-general

From Sam Mason
Subject Re: array_reverse()
Date
Msg-id 20091102150914.GJ5407@samason.me.uk
Whole thread Raw
In response to Re: array_reverse()  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mon, Nov 02, 2009 at 10:03:49AM -0500, Tom Lane wrote:
> Sam Mason <sam@samason.me.uk> writes:
> > Rotating the array by 180 degrees in every dimension would give the same
> > answer for 1-dimensional arrays and give sensible answers for higher
> > dimensional arrays.
>
> The easy implementation at the C level would be to reverse the storage
> order of the elements (and then do something-or-other with the dimension
> info, in case the array isn't square).  Your diagram suggests that this
> might be the same thing as what you suggest, but I can't work it out for
> lack of caffeine.

Yes, it is.  I hadn't worked out the code before.  Implementation should
be very easy at C level.  Not sure how NULLs are implemented in arrays,
they may require a bit more care.

--
  Sam  http://samason.me.uk/

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: array_reverse()
Next
From: Raimon Fernandez
Date:
Subject: Re: Cancelling Requests Frontend/Backend Protocol TCP/IP