Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [206.210.65.6]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA27527 for ; Thu, 10 Jun 1999 11:07:13 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id LAA09729; Thu, 10 Jun 1999 11:06:23 -0400 (EDT) To: Chris Bitmead cc: pgsql-hackers@hub.org Subject: Re: [HACKERS] BUG in 6.5 - GROUP BY inheritance In-reply-to: Your message of Thu, 10 Jun 1999 13:48:01 +1000 <375F3571.B459169B@bigfoot.com> Date: Thu, 10 Jun 1999 11:06:22 -0400 Message-ID: <9727.929027182@sss.pgh.pa.us> From: Tom Lane Chris Bitmead writes: > This is from CVS of about a week ago. > SELECT question.title, count(comment.oid) FROM question, > category*,comment WHERE comment.webobject = question.oid and > question.category = category.oid GROUP BY question.title; See my message from Sunday, "inherited GROUP BY is busted": : It turns out that pretty much *anything* involving grouping or : aggregation would fail if the query used inheritance, because the This query seems to work with current sources (although EXPLAIN fails for it --- I think that explain.c is out of sync with the executor). regards, tom lane