Received: from gyw.com (gyw.com [209.55.67.177]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4LDMGA11694 for ; Mon, 21 May 2001 09:22:16 -0400 (EDT) (envelope-from tjk@tksoft.com) Received: from smtp3.tksoft.com (smtp3.tksoft.com [192.168.50.56] (may be forged)) by gyw.com (8.8.8/8.8.8) with ESMTP id GAA26148; Mon, 21 May 2001 06:54:50 -0700 Received: (from tjk@tksoft.com) by smtp3.tksoft.com (8.8.8/8.8.8) id EAA24780; Mon, 21 May 2001 04:53:45 -0700 From: "tjk@tksoft.com" Message-Id: <200105211153.EAA24780@smtp3.tksoft.com> Subject: Re: Case insensitive string comparison? To: cedarc@visionforisrael.com (Cedar Cox) Date: Mon, 21 May 2001 04:53:45 -0700 (PDT) Cc: pgsql-sql@postgresql.org In-Reply-To: from "Cedar Cox" at May 21, 2001 12:15:41 PM X-Info: None MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Archive-Number: 200105/226 X-Sequence-Number: 3043 You can index the lower(...) queries, but you can't for the regex queries. Troy > > > On Tue, 15 May 2001, Karel Zak wrote: > > > On Tue, May 15, 2001 at 02:48:24PM +0200, Borek Lupoměský wrote: > > > Is there an operator for case insensitive string comparison, or > > > should I use regular expression matching with ~* '^string$'? > > > > possibility: > > > > - use upper() / lower() inside query > > Ok, this is probably a really silly question: which is faster? > I expect they are nearly identical code. Just wondering... > > -Cedar > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >