Received: from localhost.localdomain (h246.ozemail2.ozemail.com.au [203.108.14.246]) by hub.org (8.9.3/8.9.3) with ESMTP id XAA26280 for ; Wed, 9 Jun 1999 23:48:15 -0400 (EDT) (envelope-from chris.bitmead@bigfoot.com) Received: from bigfoot.com (localhost [127.0.0.1]) by localhost.localdomain (8.9.3/8.9.3) with ESMTP id NAA09387 for ; Thu, 10 Jun 1999 13:48:02 +1000 Sender: chris@localhost.localdomain Message-ID: <375F3571.B459169B@bigfoot.com> Date: Thu, 10 Jun 1999 13:48:01 +1000 From: Chris Bitmead X-Mailer: Mozilla 4.6 [en] (X11; I; Linux 2.2.6 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-hackers@hub.org Subject: BUG in 6.5 - GROUP BY inheritance Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit The following query produces the following error BUT... if I take out the "*" from category* it starts to work. Unfortunately I need the "*" for my purposes. Bug? 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; ERROR: replace_vars_with_subplan_refs: variable not in target list -- Chris Bitmead http://www.bigfoot.com/~chris.bitmead mailto:chris.bitmead@bigfoot.com