Chris Kratz wrote:
Hello all,
I wanted to verify what we are seeing.
Select a, aggregate(b)
from c
group by a
order by a,b
That's a rather odd query... Values in b aren't available to order by,
as they have been aggregated. There is no relation to the values in b
and the values in your result set.
You could order by "column 2" if you want to order on the results on
your aggregate:
Select a, aggregate(b)
from c
group by a
order by a,2
--
Alban Hertroys
[EMAIL PROTECTED]
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
7500 AK Enschede
// Integrate Your World //
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
