On Wed, 4 Aug 1999, sam smith wrote:
> select loser,count(*) from moves group by loser;
>
> but when i combine it with an insert into -
> insert into losses select loser,count(*) from moves group by loser;
>
> I get
> ERROR: Illegal use of aggregates or non-group column in target list
I think you want 'select loser, count(*) into losses from moves group by
loser'
Brett W. McCoy
http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
Keep Cool, but Don't Freeze
- Hellman's Mayonnaise