Postgres Pro
Downloads
Home   >   mailing lists

Re: joins on the same table with aggregates - Mailing list pgsql-bugs

From Tom Lane
Subject Re: joins on the same table with aggregates
Date
Msg-id 19423.962637069@sss.pgh.pa.us
Whole thread Raw
In response to joins on the same table with aggregates  (Darcy Buskermolen <Darcy@Wavefire.com>)
List pgsql-bugs
Tree view 
The problem's not so much the aggregates as the views.  Views containing
GROUP BY don't work properly in any but the simplest cases.  Fixing this
will take a major redesign of querytrees, which we are currently hoping
to accomplish in the 7.2 development cycle.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re:
Next
From: Tom Lane
Date:
Subject: Re: Queries with multiple USINGs crash backend