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 issue with calculating the set twice ?
Can I somehow check both (or more) values at once?
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
