Check a column value not in Array.

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Check a column value not in Array.
Date: 2008-08-14 19:07:13
Message-ID: 48A48261.7090707@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Pavel Stehule 2008-08-14 19:31:23 Re: Check a column value not in Array.
Previous Message Bruce Momjian 2008-08-12 20:48:51 Re: Re: Efficiently determining the number of bits set in the contents of, a VARBIT field