Re: problem with nested views - Mailing list pgsql-general

From Travis Bauer
Subject Re: problem with nested views
Date
Msg-id Pine.GSO.4.21.0004291611250.15083-100000@mantaray.cs.indiana.edu
Whole thread Raw
In response to problem with nested views  (Travis Bauer <trbauer@indiana.edu>)
List pgsql-general
Thank you, I think that is what it is.  I noticed that when the view
fails, it the values that are incorrect are sums of what should appear in
multiple records.  Is there any obvious way around this problem?

Thanks,
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------

On Sat, 29 Apr 2000, Stephan Szabo wrote:

>
> I believe that the problem may be that aggregates/group by in view are not
> always
> expanded correctly when they are then used in a join.
>
> >From the TODO file:
>  Views containing aggregates sometimes fail. (Jan)


pgsql-general by date:

Previous
From: Unhappy-HP-User-COMP@nfjqcapmjf.edu
Date:
Subject: ../\...HP LaserJet 3150 Users... Can You Print Landscape???^^^..
Next
From: Andrew Schmeder
Date:
Subject: Inconsistent query results...