Received: from hotmail.com (f65.law15.hotmail.com [64.4.23.65])
	by postgresql.org (Postfix) with ESMTP
	id 501B44758F3; Tue, 23 Jul 2002 10:35:36 -0400 (EDT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Tue, 23 Jul 2002 07:35:40 -0700
Received: from 137.189.4.4 by lw15fd.law15.hotmail.msn.com with HTTP;
	Tue, 23 Jul 2002 14:35:40 GMT
X-Originating-IP: [137.189.4.4]
From: "Carmen Wai" <wai_carmen@hotmail.com>
To: pgsql-sql@postgresql.org, pgsql-general@postgresql.org
Subject: Case in-sensitive
Date: Tue, 23 Jul 2002 14:35:40 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F65Ok5zzfEvxhJx5seQ00000046@hotmail.com>
X-OriginalArrivalTime: 23 Jul 2002 14:35:40.0750 (UTC)
	FILETIME=[37F9F6E0:01C23256]
X-Archive-Number: 200207/1415
X-Sequence-Number: 27902

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)

Thanks a lot!

Carmen

_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com