Re: [despammed] How to search for a subString

From: Frank Finner <postgresql(at)finner(dot)de>
To: Bruno Wolff III <bruno(at)wolff(dot)to>
Cc: andreas_kretschmer(at)despammed(dot)com, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: [despammed] How to search for a subString
Date: 2005-02-06 15:03:48
Message-ID: 20050206160348.059c695b.postgresql@finner.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)wolff(dot)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

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Kretschmer Andreas 2005-02-06 15:11:45 Re: [despammed] How to search for a subString
Previous Message Bruno Wolff III 2005-02-06 13:32:20 Re: [despammed] How to search for a subString