> 
> 
> => > 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.
> It works.
> => 
> But, just wanted to check this also.
> I get the same error for:
> insert into FTemp1 select item, count(*) as cnt from data group by item
> also.
> 
> So, is it mandatory now to give alias names for all the selected columns if
> we are using group by

No, I am sorry.  Looks like we have a bug where GROUP BY can't be used
with INSERT ... SELECT.


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

Fri, 20 Feb 1998 14:29:08 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] group by problem