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
In response to
pgsql-interfaces by date
|Next:||From: Chad Robinson||Date: 2005-02-07 15:05:04|
|Subject: Problem with asynchronous connect in 8.0.1|
|Previous:||From: Nick Burch||Date: 2005-02-07 14:17:46|
|Subject: Re: PGXML|