Postgres Pro
Downloads
Home   >   mailing lists

Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support? - Mailing list pgsql-sql

From Tom Lane
Subject Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?
Date
Msg-id 17497.1314719596@sss.pgh.pa.us
Whole thread Raw
In response to Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?  (Emi Lu <emilu@encs.concordia.ca>)
Responses Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-sql
Tree view 
Emi Lu <emilu@encs.concordia.ca> writes:
> On 08/30/2011 11:24 AM, Tom Lane wrote:
>> select * from tablename
>> where not (col1 ~~* any(array['str1%', 'str2%'... 'strN%']));

> If next version could have "not ilike ('', '')" added into window 
> functions, that's will be great!

Why?  And what's this got to do with window functions?
        regards, tom lane

pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?
Next
From: Emi Lu
Date:
Subject: Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?