You can write condition in subquery: where 0=(select count(*) from myfunction(id) where x in (10,20))
2011/9/24, Andreas <maps...@gmx.net>: > 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 > -- ------------ pasman -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
