> "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
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
> --
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