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

From: Emre Hasegeli <hasegeli(at)tart(dot)com(dot)tr>
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-31 07:16:17
Message-ID: CAE2gYzxQTF9qT9difEALzsFKrmLabDONvtsOoMz+eNFQsGD=gg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

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