Re: Sorting items in aggregate function (thanks) - Mailing list pgsql-sql

On Tue, Sep 12, 2006 at 04:37:55PM -0400, Tom Lane wrote:
> Note that if you need to GROUP in the outer query, it's best to sort the
> inner query's output first by the outer query's grouping:
...

Great - this works fine. Thanks also to the other people who replied.

Steven.

--
w: http://www.cl.cam.ac.uk/users/sjm217/