Re: [HACKERS] group by problem

>
>
> => > 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(at)candle(dot)pha(dot)pa(dot)us