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