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