Received: from mail.libertyrms.com (unknown [216.94.172.167]) by postgresql.org (Postfix) with ESMTP id 96572475BC4 for ; Tue, 23 Jul 2002 10:46:28 -0400 (EDT) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 17X0vp-0007Dc-00 for ; Tue, 23 Jul 2002 10:46:33 -0400 Date: Tue, 23 Jul 2002 10:46:33 -0400 From: Andrew Sullivan To: pgsql-general@postgresql.org Subject: Re: Case in-sensitive Message-ID: <20020723104633.E23294@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , pgsql-general@postgresql.org References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from wai_carmen@hotmail.com on Tue, Jul 23, 2002 at 02:35:40PM +0000 X-Archive-Number: 200207/1419 X-Sequence-Number: 27906 On Tue, Jul 23, 2002 at 02:35:40PM +0000, Carmen Wai wrote: > Hello: > > Can I config the Postgresql so that it can match case in-sensitive pattern > automatically? i.e. I don't need to explicit convert the pattern to lower > case like this: .....WHERE lower(textfield) LIKE lower(pattern) No. But you can use ILIKE, which is a case-insensitive LIKE. A -- ---- Andrew Sullivan 87 Mowat Avenue Liberty RMS Toronto, Ontario Canada M6K 3E3 +1 416 646 3304 x110