Re: [SQL] Check a column value not in Array.

2008/8/14 Emi Lu <[EMAIL PROTECTED]>: > 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']; > select * from test where test.col <> ALL ( ARR

Re: [SQL] Check a column value not in Array.

Hello 2008/8/14 Emi Lu <[EMAIL PROTECTED]>: > 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! postgres=# select 1 = any(ar

[SQL] Check a column value not in Array.

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 subsc