| From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | Jan Wieck <jwieck(at)debis(dot)com> |
| Cc: | "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su>, PostgreSQL HACKERS <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] Views on aggregates - need assistence |
| Date: | 1998-02-24 06:49:56 |
| Message-ID: | 34F26D94.954F2734@alumni.caltech.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> > 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 :(
Well, there may be a subset of the possible cases which could work?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Maurice Gittens | 1998-02-24 07:10:19 | Re: [HACKERS] How To free resources used by large object Relations? |
| Previous Message | Tom I Helbekkmo | 1998-02-24 05:44:28 | Re: [HACKERS] Current 6.3 issues |