BUG in 6.5 - GROUP BY inheritance

Поиск
Список
Период
Сортировка
Искать
От
chris@tech.com.au
Тема
BUG in 6.5 - GROUP BY inheritance
Дата
Msg-id
199906091443.AAA26884@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

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Tom Lane
Дата:
FAQ