Received: from tech.com.au (IDENT:root@techpt.lnk.telstra.net [139.130.75.122]) by hub.org (8.9.3/8.9.3) with ESMTP id KAA00777 for ; Wed, 9 Jun 1999 10:43:39 -0400 (EDT) (envelope-from chris@tech.com.au) From: chris@tech.com.au Received: (from chris@localhost) by tech.com.au (8.9.3/8.9.3) id AAA26884; Thu, 10 Jun 1999 00:43:22 +1000 Date: Thu, 10 Jun 1999 00:43:22 +1000 Message-Id: <199906091443.AAA26884@tech.com.au> To: pgsql-hackers@hub.org Subject: BUG in 6.5 - GROUP BY inheritance Cc: chris@tech.com.au 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