Re: array_reverse()

From: Sam Mason <sam(at)samason(dot)me(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: array_reverse()
Date: 2009-11-02 14:51:59
Message-ID: 20091102145159.GH5407@samason.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Nov 02, 2009 at 09:20:38AM -0500, Tom Lane wrote:
> Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> writes:
> > Before I go ahead and try to write a decent quality version: is there
> > any chance an array_reverse() function (in C) would be accepted into Pg
> > mainline?
>
> What would it mean for a multi-dimensional array?

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. For example:

1,2,3 == 3,2,1

[1 2 3 [9 8 7
4 5 6 == 6 5 4
7 8 9] 3 2 1]

I think higher dimensionality would work, it's just a bit fiddly to
draw.

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-11-02 14:53:06 Re: pk vs unique not null differences between 8.3.4 and 8.3.8
Previous Message Tom Lane 2009-11-02 14:41:49 Re: Error on compile for Windows