Re: Box query

From: Mikito Harakiri <mikharakiri_nospaum_at_yahoo.com>
Date: 21 Apr 2006 19:49:45 -0700
Message-ID: <1145674185.144296.93480@v46g2000cwv.googlegroups.com>

Mikito Harakiri wrote:
> The next question that I was going to ask: "find the intersection volume".

Which naturally leads to one more intersection query:

select b1.id as box1, b2.id as box2
from boxes b1, boxes b2
where b1.dim = b2.dim
group by b1.id, b2.id
having 0.1 < exp(sum(ln(

case when b2.low between b1.low and b1.high then b1.high-b2.low else 0.00000001 end
)))
;

This doesn't look like relational division at all... Received on Fri Apr 21 2006 - 21:49:45 CDT