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

From Pavel Stehule
Subject Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?
Date
Msg-id CAFj8pRBotEwp-0t0Ys=zww=dkSWRT1ESdHn=ZkFBvgWY+LGKZQ@mail.gmail.com
Whole thread Raw
In response to Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-sql
2011/8/31 Emi Lu <emilu@encs.concordia.ca>:
> On 08/31/2011 03:16 AM, Emre Hasegeli wrote:
>>
>> 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)".
>
>
> What I mean is ilike ('%str1%', ... '%strN%')
>
> I just forgot to put %

it useless to introduce non SQL feature where some native feature exists now.

Regards

Pavel Stehule


>
> Emi
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>


pgsql-sql by date:

Previous
From: lxnf98mm@comcast.net
Date:
Subject: ERROR: cannot subscript type text because it is not an array
Next
From: Viktor Bojović
Date:
Subject: function based index problem