first-draft patch for aggregate ORDER BY - Mailing list pgsql-hackers

From Andrew Gierth
Subject first-draft patch for aggregate ORDER BY
Date
Msg-id 873a5ynes6.fsf@news-spur.riddles.org.uk
Whole thread Raw
List 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

pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: commented out para in docs
Next
From: Tom Lane
Date:
Subject: Re: Making hash indexes worthwhile