Hi,
assoc=> explain insert into f2_temp select p.item, q.item, count(*) as cnt
from t1 p, t1 q where p.tid = q.tid and p.item < q.item group by p.item,
q.item;
ERROR: The field being grouped by must appear in the target list
However, it works this way:
assoc=> explain select p.item, q.item, count(*) as cnt into table f2_temp from
t1 p, t1 q where p.tid = q.tid and p.item < q.item group by p.item, q.item;
NOTICE: QUERY PLAN:
--shiby