2011/8/30 Emi Lu <em...@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 -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
