Thread

1. group by problem

   Shiby Thomas <sthomas@cise.ufl.edu> — 1998-02-20T18:55:29Z

   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
   
   
   
   

2. Re: [HACKERS] group by problem

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-02-20T19:16:14Z

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