Puuuurfect! This is exactly what I needed. Didn't know postgres
supported subselects like that. Thanks.
-Michael
> select min(amtsum), max(amtsum), avg(amtsum)
> from (select sum(amount) as amtsum from payments group by userid)
> ss;
>
> In prior versions you'd need to do the initial select into a temp
> table and then select min/max/avg from that.
_________________________________________________________________
http://fastmail.ca/ - Fast Free Web Email for Canadians
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
