Received: from smtp1.alehop.com ([62.81.160.67]) by hub.org (8.10.1/8.10.1) with ESMTP id e7TMqYC85403 for ; Tue, 29 Aug 2000 18:52:34 -0400 (EDT) Received: from txino.mikasa.eh ([62.82.66.34]) by smtp1.alehop.com (Netscape Messaging Server 4.15) with SMTP id G02SWQ01.O0G for ; Wed, 30 Aug 2000 00:53:14 +0200 From: "J. Fernando Moyano" Organization: SymeX To: pgsql-sql@postgresql.org Subject: Problems with complex queries ... Date: Wed, 30 Aug 2000 00:46:18 +0200 X-Mailer: KMail [version 1.0.28] Content-Type: text/plain MIME-Version: 1.0 Message-Id: <00083000494302.01170@txino.mikasa.eh> Content-Transfer-Encoding: 8bit X-Archive-Number: 200008/328 Hey everybody !!! I am new on this list !!! I have a little problem ..... 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 but if I try this one: "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)" It's OK !! What's up??? Do you think i found a bug ??? Do exists some limitation like this in subqueries?? (Perhaps Postgres don't accept using aggregates in subqueries ???) I tried this too: "select n_lote from pedidos where n_lote not in (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))" but the result was the same ! And i get the same error message (or similar) when i try other variations. Thanks !!! Fer -- ************* ****** ****** ********** ***** ***** ******* ************* ***** ****** ********** ****** ***** *********** ***** ******** **** ************* **** **** ***** **** **** ***** ******* **** **** ***** ******* **** ***** ****** **** **** ***** ****** ***** ********* ***** ***** ************ ***** ****** ****** ********* ***** ***** ******** (*) SymeX ==> http://www.lantik.com (*) Web en http://www.arrakis.es/~txino (*) Informate sobre LINUX en http://www.linux.org