Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1546dx49147; Sun, 4 Feb 2001 23:06:39 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f1546Y907957; Sun, 4 Feb 2001 23:06:34 -0500 (EST) To: "omid omoomi" cc: pgsql-general@postgresql.org, pgsql-sql@postgresql.org Subject: Re: Aggregates and joined tables... In-reply-to: References: Comments: In-reply-to "omid omoomi" message dated "Sun, 04 Feb 2001 21:42:16" Date: Sun, 04 Feb 2001 23:06:33 -0500 Message-ID: <7954.981345993@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/125 X-Sequence-Number: 3958 "omid omoomi" writes: > The platform is PostgreSQL 6.5.2 on i386-unknown-freebsd3.2, compiled by gcc > 2.7.2.1 . > I want to write a query which looks like this : > select fa1 - sum(fc3) > from A,B,C > where fa1=fb1 and fb2=fc2 > group by fa1 ; > unfortunately I get this in result: > ERROR: Illegal use of aggregates or non-group column in target list Works fine in current sources. Try upgrading to something newer than 6.5.2 ... regards, tom lane