Better way to check more than 1 value NOT IN (...)

Поиск
Список
Период
Сортировка
От Andreas
Тема Better way to check more than 1 value NOT IN (...)
Дата
Msg-id 4E7DA528.9010902@gmx.net
обсуждение исходный текст
Ответы Re: Better way to check more than 1 value NOT IN (...)
Список pgsql-sql
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?


В списке pgsql-sql по дате отправления: