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