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

Emi Lu <emilu@encs.concordia.ca> writes:
> Does psql provide something like the following query command?

> select * from tablename
> where col1 not ilike ('str1%', 'str2%'... 'strN%')

If you remember the operator name equivalent to ILIKE (~~*)
you can do

select * from tablename
where not (col1 ~~* any(array['str1%', 'str2%'... 'strN%']));
        regards, tom lane