Postgres Pro
Downloads
Home   >   mailing lists

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

From Emre Hasegeli
Subject Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?
Date
Msg-id CAE2gYzxQTF9qT9difEALzsFKrmLabDONvtsOoMz+eNFQsGD=gg@mail.gmail.com
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 
2011/8/30 Emi Lu <emilu@encs.concordia.ca>:

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

It is not. It is like "where id = (3, 5, 7)".

--
Emre Hasegeli
Veri Tabanı Yöneticisi
Tart İnternet Teknolojileri AŞ
tart.com.tr

pgsql-sql by date:

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