Postgres Pro
Downloads
Home   >   mailing lists

Better way to check more than 1 value NOT IN (...) - Mailing list pgsql-sql

From Andreas
Subject Better way to check more than 1 value NOT IN (...)
Date
Msg-id 4E7DA528.9010902@gmx.net
Whole thread Raw
Responses Re: Better way to check more than 1 value NOT IN (...)
List pgsql-sql
Tree view 
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 by date:

Previous
From: Andreas
Date:
Subject: Howto build a funtion that selects an id or inserts a value
Next
From: pasman pasmański
Date:
Subject: Re: Better way to check more than 1 value NOT IN (...)