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

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

pgsql-interfaces by date

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

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