Re: [despammed] How to search for a subString

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Frank Finner <postgresql(at)finner(dot)de>
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-07 14:35:55
Message-ID: 20050207143555.GA28894@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

On Sun, Feb 06, 2005 at 16:03:48 +0100,
Frank Finner <postgresql(at)finner(dot)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.

In response to

Browse pgsql-interfaces by date

  From Date Subject
Next Message Chad Robinson 2005-02-07 15:05:04 Problem with asynchronous connect in 8.0.1
Previous Message Nick Burch 2005-02-07 14:17:46 Re: PGXML