>Can the question be rephrased as you being interested in which sets are
>identical, Elias? If I understand things correctly,
>I would assume "double negation" to be the "simple" answer you're looking for:
>
>with tmp(id) as
>(select distinct id from CRITICALPARAMVALS)
>
>select t.id, t2.id
>from tmp t
>join tmp t2 on t.id < t2.id
>where not exists(select * from CRITICALPARAMVALS a
> where t.id = a.id
> and not exists(select * from CRITICALPARAMVALS b
> where t2.id = b.id
> and a.PARAM=b.param and (exists (select
> isequal from TEST_FLOAT_EQ(a.val, b.val, 1e-5) where ISEQUAL=1))))
Sorry, the above select returns equal sets, but also sets where B is a superset
of A. You need to add
and not exists(select * from CRITICALPARAMVALS a
where t2.id = a.id
and not exists(select * from CRITICALPARAMVALS b
where t.id = b.id
and a.PARAM=b.param and (exists (select *
from TEST_FLOAT_EQ(a.val, b.val, 1e-5) where ISEQUAL=1))))
for it to only find identical sets.
Needless to say, such a query can be a bit slow with huge tables. Moreover, I
don't know how TEST_FLOAT_EQ is implemented or why you use this rather than
a.val BETWEEN b.val - 0.00001 and b.val + 0.00001
HTH,
Set
