Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Views on aggregates - need assistence

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 (view raw or flat)
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?


In response to

pgsql-hackers by date

Next:From: Maurice GittensDate: 1998-02-24 07:10:19
Subject: Re: [HACKERS] How To free resources used by large object Relations?
Previous:From: Tom I HelbekkmoDate: 1998-02-24 05:44:28
Subject: Re: [HACKERS] Current 6.3 issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group