Is this a parser error ?
Shiby Thomas <sthomas@cise.ufl.edu>
From: Shiby Thomas <sthomas@cise.ufl.edu>
To: The Hermit Hacker <scrappy@hub.org>
Cc: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>, pgsql-hackers@postgreSQL.org
Date: 1998-02-04T17:56:53Z
Lists: pgsql-hackers
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