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

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

Hi Tom,

>>> 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?

First, where not (col1 ~~* any(array['str1%', 'str2%'... 'strN%'])) will
work for me.

But I feel " ilike ('str1', ... 'strN')" is more intuitive, isn't it?

I have a feeling that windows functions deal with all fancy functions. I
would consider ilike ('str'...) as a non-standard SQL command?

Emi

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Emre Hasegeli 2011-08-31 07:16:17 Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?
Previous Message Tom Lane 2011-08-30 15:53:16 Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?