On 08/31/2011 03:16 AM, Emre Hasegeli wrote:
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)".
What I mean is ilike ('%str1%', ... '%strN%')
I just forgot to put %
Emi
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql