From: Bruno Wolff III <bruno@wolff.to>
To: Frank Finner <postgresql@finner.de>
Cc: andreas_kretschmer@despammed.com
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [despammed] How to search for a subString
Date: Mon, 7 Feb 2005 08:35:55 -0600
Message-ID: <20050207143555.GA28894@wolff.to> (raw)
In-Reply-To: <20050206160348.059c695b.postgresql@finner.de>
References: <20050206101246.28648.qmail@web61003.mail.yahoo.com>
<20050206104520.GA3405@kaufbach.delug.de>
<20050206133220.GB952@wolff.to>
<20050206160348.059c695b.postgresql@finner.de>
On Sun, Feb 06, 2005 at 16:03:48 +0100,
Frank Finner <postgresql@finner.de> wrote:
> Do REs automatically ignore case? Otherwise it is clear that ~ 'the
> fast' cannot find 'The fast and the furious'. The search
> expressions should be all uppercased or lowercased then.
No they don't. I missed that when following up to the previous suggestion.
You need to use the ~* operator instead of ~ to get case insensitive
regular expressions.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: bruno@wolff.to, postgresql@finner.de, andreas_kretschmer@despammed.com
Subject: Re: [despammed] How to search for a subString
In-Reply-To: <20050207143555.GA28894@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox