Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?

use a regex ?

On 08/30/2011 16:51, Emi Lu wrote:
> Good morning,
>
> Does psql provide something like the following query command?
>
> select * from tablename
> where col1 not ilike ('str1%', 'str2%'... 'strN%')
>
> Thanks a lot!
> Emi
>


--
No trees were killed in the creation of this message.
However, many electrons were terribly inconvenienced.