Home > mailing lists

group by problem - Mailing list pgsql-hackers

From	Shiby Thomas
Subject	group by problem
Date	February 20, 1998 16:56:14
Msg-id	199802201855.NAA01552@cise.ufl.edu Whole thread Raw
Responses	Re: [HACKERS] group by problem (Bruce Momjian <maillist@candle.pha.pa.us>)
List	pgsql-hackers

Tree view

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

pgsql-hackers by date:

From: ocie@paracel.com
Date: 20 February 1998, 16:39:26
Subject: Re: [HACKERS] Subselects and NOTs

From: jwieck@debis.com (Jan Wieck)
Date: 20 February 1998, 16:59:32
Subject: Backend crashes - what's going on here???

group by problem - Mailing list pgsql-hackers

Previous

Next