Re: [HACKERS] Views on aggregates - need assistence

Jan Wieck wrote:
>
> Hi,
>
> the first step on views using aggregate was successful. But
> I don't know enough about GROUP BY, HAVING and all the other
> stuff. So I need someone to assist me in getting the rewrite
> system to handle this kind of views properly.

...

>
> Before going into details and fixing more things I must have
> some different view definitions and table settings (including
> nested views with and without aggregates) and what they are
> expected to output!
>
> And please some complicated select statements building joins
> from tables and the views with GROUP BY etc. too if possible.

create view v as select x, sum(y) as sy from A group by x;
select * from B, V where B.z = V.sy;

- how can we handle this (aggregates in WHERE) ?
It seems that current VIEW implementation using RULEs has
unresolvable problems :(

Vadim