Re: Sorting items in aggregate function (thanks)

From: Steven Murdoch <psql+Steven(dot)Murdoch(at)cl(dot)cam(dot)ac(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Sorting items in aggregate function (thanks)
Date: 2006-09-15 09:15:09
Message-ID: 20060915091509.GA32646@cl.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message gould 2006-09-15 09:16:06 Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4
Previous Message Amit_Wadhwa 2006-09-15 08:50:13 Re: lower() not working correctly...?