first-draft patch for aggregate ORDER BY

From: Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>
To: pgsql-hackers(at)postgresql(dot)org
Subject: first-draft patch for aggregate ORDER BY
Date: 2009-10-05 13:36:41
Message-ID: 873a5ynes6.fsf@news-spur.riddles.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

What it does:

# select array_agg(b order by a)
from (values (3,'foo'),(2,'bar'),(1,'baz')) v(a,b);
array_agg
---------------
{baz,bar,foo}
(1 row)

What it doesn't do:

- no docs or regression tests yet

- no support for agg(... ORDER BY ...) OVER window
(which the spec does allow)

Requires initdb. Beware of bugs. Slippery when wet.

--
Andrew (irc:RhodiumToad)

Attachment Content-Type Size
aorder-20091005.patch.gz application/octet-stream 12.2 KB

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-10-05 13:49:43 Re: Making hash indexes worthwhile
Previous Message Kevin Grittner 2009-10-05 13:31:35 Re: commented out para in docs