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
Didn't test this, but I think it should also work:
SELECT a.oid_fld
FROM for_payment a, for_payment b
WHERE b.serial_fld = 2
AND b.char_fld = a.char_fld
AND a.serial_fld <> 2
--
Renato
Sao Paulo - SP - Brasil
[EMAIL PROTECTED]
> Is there a better way to write this:
>
> SELECT a.oid_fld FROM for
