Received: from sss2.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.10.1/8.10.1) with ESMTP id e7TNMGC90647 for ; Tue, 29 Aug 2000 19:22:16 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss2.sss.pgh.pa.us (8.9.3/8.9.3) with ESMTP id TAA17349; Tue, 29 Aug 2000 19:21:58 -0400 (EDT) To: "J. Fernando Moyano" cc: pgsql-sql@postgresql.org Subject: Re: Problems with complex queries ... In-reply-to: <00083000494302.01170@txino.mikasa.eh> References: <00083000494302.01170@txino.mikasa.eh> Comments: In-reply-to "J. Fernando Moyano" message dated "Wed, 30 Aug 2000 00:46:18 +0200" Date: Tue, 29 Aug 2000 19:21:57 -0400 Message-ID: <17346.967591317@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200008/329 "J. Fernando Moyano" writes: > I try this on my system: (Postgres 6.5.2, Linux) > "select n_lote from pedidos except select rp.n_lote from relpedidos rp, > relfacturas rf where rp.n_lote=rf.n_lote group by rp.n_lote having > sum(rp.cantidad)=sum(rf.cantidad)" > and I get this result: > ERROR: rewrite: comparision of 2 aggregate columns not supported I think this is fixed in 7.0. regards, tom lane