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

From Julien Cigar
Subject Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?
Date
Msg-id 4E5CFB64.5060409@ulb.ac.be
Whole thread Raw
In response to where col1 not ilike ('str1%', 'str2%'... 'strN%') support?  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-sql
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.

Attachment

pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?
Next
From: Tom Lane
Date:
Subject: Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?