group by problem

From: Shiby Thomas <sthomas(at)cise(dot)ufl(dot)edu>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: group by problem
Date: 1998-02-20 18:55:29
Message-ID: 199802201855.NAA01552@cise.ufl.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 1998-02-20 19:06:31 Backend crashes - what's going on here???
Previous Message ocie 1998-02-20 18:36:27 Re: [HACKERS] Subselects and NOTs