Re: [HACKERS] agg/order-by question

2003-07-12 Thread Sailesh Krishnamurthy
> "Bruno" == Bruno Wolff, writes: Bruno> You might try this in 7.4. I am pretty sure a change was Bruno> made a couple of weeks ago to let group by work with either Bruno> sort order. Also hash aggragates have been available for Bruno> quite a while in 7.4. This is a better pl

Re: [HACKERS] agg/order-by question

2003-07-12 Thread Bruno Wolff III
On Sat, Jul 12, 2003 at 00:39:06 -0700, Sailesh Krishnamurthy <[EMAIL PROTECTED]> wrote: > > Consider the explain for the following queries .. > > sample=# explain select a, count(*) from foo group by a order by a; >QUERY PLAN > --

[HACKERS] agg/order-by question

2003-07-12 Thread Sailesh Krishnamurthy
Consider the explain for the following queries .. sample=# explain select a, count(*) from foo group by a order by a; QUERY PLAN - Aggregate (cost=69.83..77.33 rows=100 width=4) -> Group