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

From Steven Murdoch
Subject Re: Sorting items in aggregate function (thanks)
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: Sorting items in aggregate function  (Tom Lane <[email protected]>)
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/

pgsql-sql by date:

Previous
From:
Date:
Subject: Re: lower() not working correctly...?
Next
From: [email protected]
Date:
Subject: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4