"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