Received: from all.all.ee (puu.all.ee [194.204.49.113]) by hub.org (8.10.1/8.10.1) with ESMTP id e65BExS72543 for ; Wed, 5 Jul 2000 07:14:59 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by all.all.ee (8.9.3/8.9.3) with ESMTP id OAA14394 for ; Wed, 5 Jul 2000 14:14:55 +0300 Date: Wed, 5 Jul 2000 14:14:55 +0300 (EEST) From: Antti Linno To: pgsql-sql@postgresql.org Subject: GROUP by Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200007/29 I have table job, and I want to select data from it, grouping by workgroups. When I use select id,name from job where workgroup='top leaders' AND ... group by workgroup; When I want to group, I get ERROR: Illegal use of aggregates or non-group column in target list I'm confused, why does query work only with sum,min etc. alone in select. Antti