Horton

Re: joins on the same table with aggregates

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Darcy Buskermolen <Darcy@Wavefire.com>
Cc: pgsql-bugs@postgresql.org
Date: 2000-07-03T15:11:09Z
Lists: pgsql-bugs 
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