Re: Problems with complex queries ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "J(dot) Fernando Moyano" <txinete(at)wanadoo(dot)es>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Problems with complex queries ...
Date: 2000-08-29 23:21:57
Message-ID: 17346.967591317@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"J. Fernando Moyano" <txinete(at)wanadoo(dot)es> 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Webb Sprague 2000-08-30 00:04:52 Optimizing huge inserts/copy's
Previous Message Stephan Szabo 2000-08-29 23:19:41 Re: Problems with complex queries ...