Thread: group by problem

group by problem

From

Shiby Thomas

Date:

20 February 1998, 16:56:14

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

Re: [HACKERS] group by problem

From

Bruce Momjian

Date:

20 February 1998, 17:17:14

>
> 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

Say:

group by item1.



--
Bruce Momjian
maillist@candle.pha.pa.us