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

From: Julien Cigar <jcigar(at)ulb(dot)ac(dot)be>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?
Date: 2011-08-30 15:01:56
Message-ID: 4E5CFB64.5060409@ulb.ac.be
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
jcigar.vcf text/x-vcard 292 bytes

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2011-08-30 15:24:36 Re: where col1 not ilike ('str1%', 'str2%'... 'strN%') support?
Previous Message Emi Lu 2011-08-30 14:51:36 where col1 not ilike ('str1%', 'str2%'... 'strN%') support?