Thread

Is this a parser error ?

Shiby Thomas <sthomas@cise.ufl.edu> — 1998-02-04T17:56:53Z

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