| From: | Travis Bauer <trbauer(at)indiana(dot)edu> |
|---|---|
| To: | Stephan Szabo <sszabo(at)kick(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: problem with nested views |
| Date: | 2000-04-29 21:13:51 |
| Message-ID: | Pine.GSO.4.21.0004291611250.15083-100000@mantaray.cs.indiana.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Schmeder | 2000-04-30 03:54:27 | what does this error mean? |
| Previous Message | Andrew Schmeder | 2000-04-29 20:53:58 | Re: Inconsistent query results... |