You can write condition in subquery:
where 0=(select count(*) from myfunction(id) where x in (10,20))
2011/9/24, Andreas :
> Hi,
> I've got to check if 2 values are not in a set that is dynamically
> calculated by a function.
>
> The query looks like
>
> select some_id,
> from .
> whe
Hi,
I've got to check if 2 values are not in a set that is dynamically
calculated by a function.
The query looks like
select some_id,
from .
where 10 is not in ( select x from my_function (some_id))
and 20 is not in ( select x from my_function (some_id))
Is there a efficiency
