From: Frank Finner <postgresql@finner.de>
To: Bruno Wolff III <bruno@wolff.to>
Cc: andreas_kretschmer@despammed.com
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [despammed] How to search for a subString
Date: Sun, 6 Feb 2005 16:03:48 +0100
Message-ID: <20050206160348.059c695b.postgresql@finner.de> (raw)
In-Reply-To: <20050206133220.GB952@wolff.to>
References: <20050206101246.28648.qmail@web61003.mail.yahoo.com>
<20050206104520.GA3405@kaufbach.delug.de>
<20050206133220.GB952@wolff.to>
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.
Regards, Frank.
On Sun, 6 Feb 2005 07:32:20 -0600 Bruno Wolff III <bruno@wolff.to>
thought long, then sat down and wrote:
> As REs are unanchored, you can simplify this to:
> select .. ~ 'the fast' ...
>
> However, ilike should have worked if it was used properly.
--
Frank Finner
Köpfchenstraße 36
57072 Siegen
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: postgresql@finner.de, bruno@wolff.to, andreas_kretschmer@despammed.com
Subject: Re: [despammed] How to search for a subString
In-Reply-To: <20050206160348.059c695b.postgresql@finner.de>
* 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