where col1 not ilike ('str1%', 'str2%'... 'strN%') support?

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?
Date: 2011-08-30 14:51:36
Message-ID: 4E5CF8F8.7030404@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Good morning,

Does psql provide something like the following query command?

select * from tablename
where col1 not ilike ('str1%', 'str2%'... 'strN%')

Thanks a lot!
Emi

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Julien Cigar 2011-08-30 15:01:56 Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?
Previous Message Jan Eskilsson 2011-08-28 10:00:21 Re: [SQL] parsing audit table