select *
from test
where test.col not in ARRAY['val1', 'val2'];
select * from test where test.col <> ALL ( ARRAY['val1', 'val2'] );
see http://www.postgresql.org/docs/current/static/functions-comparisons.html
be careful with NULLs in this type of comparisons.
Thanks a lot for all your inputs!
For efficiency, I guess :
(1) "... where test.col <> all ARRAY['val1', 'val2']"
and
(2) "... where test.col not in ('var1', 'var2')"
provide the same query efficiency right?
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
