> > 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?
In response to
pgsql-hackers by date
|Next:||From: Maurice Gittens||Date: 1998-02-24 07:10:19|
|Subject: Re: [HACKERS] How To free resources used by large object Relations?|
|Previous:||From: Tom I Helbekkmo||Date: 1998-02-24 05:44:28|
|Subject: Re: [HACKERS] Current 6.3 issues|