X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CFD958B9E6E for ; Mon, 7 Feb 2005 14:21:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 67651-03 for ; Mon, 7 Feb 2005 14:21:06 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id D81DF8B9CF7 for ; Mon, 7 Feb 2005 14:21:09 +0000 (GMT) Received: (qmail 29005 invoked by uid 500); 7 Feb 2005 14:35:55 -0000 Date: Mon, 7 Feb 2005 08:35:55 -0600 From: Bruno Wolff III To: Frank Finner Cc: andreas_kretschmer@despammed.com, pgsql-interfaces@postgresql.org Subject: Re: [despammed] How to search for a subString Message-ID: <20050207143555.GA28894@wolff.to> Mail-Followup-To: Frank Finner , andreas_kretschmer@despammed.com, pgsql-interfaces@postgresql.org References: <20050206101246.28648.qmail@web61003.mail.yahoo.com> <20050206104520.GA3405@kaufbach.delug.de> <20050206133220.GB952@wolff.to> <20050206160348.059c695b.postgresql@finner.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050206160348.059c695b.postgresql@finner.de> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/14 X-Sequence-Number: 5259 On Sun, Feb 06, 2005 at 16:03:48 +0100, Frank Finner 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.