Check a column value not in Array. - Mailing list pgsql-sql

From Emi Lu
Subject Check a column value not in Array.
Date
Msg-id 48A48261.7090707@encs.concordia.ca
Whole thread Raw
Responses Re: Check a column value not in Array.  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: Check a column value not in Array.  ("Filip Rembiałkowski" <plk.zuber@gmail.com>)
List pgsql-sql
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!


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: Efficiently determining the number of bits set in the contents of, a VARBIT field
Next
From: "Pavel Stehule"
Date:
Subject: Re: Check a column value not in Array.