group by problem

Shiby Thomas <sthomas@cise.ufl.edu>

From: Shiby Thomas <sthomas@cise.ufl.edu>
To: pgsql-hackers@postgreSQL.org
Date: 1998-02-20T18:55:29Z
Lists: pgsql-hackers
Hi,

I get the foll. error for a group by query:
This is with the snapshot of Feb 20, and I am running on sparc-solaris 2.6

insert into FTemp1 select item as item1, count(*) as cnt from data group by 
item;
ERROR:  The field being grouped by must appear in the target list

Thanks
--shiby