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