[SQL] Check a column value not in Array.

[Emi Lu]

Greetings,

May I know the command to check whether a column value is in array please?

For example, I am looking  for sth like:

select *
from   test
where  test.col not in ARRAY['val1', 'val2'];

Thanks!

--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql