Re: sub-select with aggregate

Uz.ytkownik Stephan Szabo napisa?:
> Does using X.group_id=3 in the where clause work better?
It works better, but not if you want to create a view and make
"select * from some_view where group_id=3" :-(
> 
> On 7.3 with no statistics for the table, that appears
> to move the filter into the subquery plan rather than the
> outer users scan.
Do you mean the second query will work on 7.3?
select  group_id,  user_id,  a/sum_a as percent_a,  b/sum_b as percent_b
from  users U,  (select    sum(a) as sum_a,    sum(b) as sum_b   from users where group_id=U.group_id) X
where group_id=3;

Tomasz Myrta