| 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: | Whole Thread | Raw Message | 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 |
| 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 |