Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group