From: | "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su> |
---|---|
To: | Jan Wieck <jwieck(at)debis(dot)com> |
Cc: | PostgreSQL HACKERS <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | Re: [HACKERS] Views on aggregates - need assistence |
Date: | 1998-02-24 02:29:25 |
Message-ID: | 34F23085.E69CCD06@sable.krasnoyarsk.su |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-02-24 02:37:02 | Re: [HACKERS] Here it is - view permissions |
Previous Message | Thomas G. Lockhart | 1998-02-24 02:16:00 | Re: [HACKERS] Subselects and NOTs |