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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: emilu(at)encs(dot)concordia(dot)ca
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?
Date: 2011-08-30 15:53:16
Message-ID: 17497.1314719596@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Emi Lu <emilu(at)encs(dot)concordia(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Emi Lu 2011-08-30 15:57:10 Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?
Previous Message Emi Lu 2011-08-30 15:48:38 Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?