Re: array_reverse()

Поиск
Список
Период
Сортировка
От Sam Mason
Тема Re: array_reverse()
Дата
Msg-id 20091102145159.GH5407@samason.me.uk
обсуждение исходный текст
Ответ на Re: array_reverse()  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: array_reverse()
Re: array_reverse()
Список pgsql-general
On Mon, Nov 02, 2009 at 09:20:38AM -0500, Tom Lane wrote:
> Craig Ringer <craig@postnewspapers.com.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/

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Error on compile for Windows
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pk vs unique not null differences between 8.3.4 and 8.3.8