
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

Thu, 10 Jun 1999 00:43:22 +1000
chris@tech.com.au
BUG in 6.5 - GROUP BY inheritance