Re: [despammed] How to search for a subString - Mailing list pgsql-interfaces

From Frank Finner
Subject Re: [despammed] How to search for a subString
Date
Msg-id 20050206160348.059c695b.postgresql@finner.de
Whole thread Raw
In response to Re: [despammed] How to search for a subString  (Bruno Wolff III <bruno@wolff.to>)
Responses Re: [despammed] How to search for a subString  (Kretschmer Andreas <andreas_kretschmer@despammed.com>)
Re: [despammed] How to search for a subString  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-interfaces
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

pgsql-interfaces by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: [despammed] How to search for a subString
Next
From: Kretschmer Andreas
Date:
Subject: Re: [despammed] How to search for a subString