Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-general-owner+M202328=pgsql-general-arkari@postgresql.org>)
 id 1VqdTU-000663-3C
 for pgsql-general@arkaria.postgresql.org; Wed, 11 Dec 2013 06:40:48 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-general-owner+M202328=pgsql-general-arkari@postgresql.org>)
 id 1VqdTT-0001Ku-EP
 for pgsql-general@arkaria.postgresql.org; Wed, 11 Dec 2013 06:40:47 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <pierce@hogranch.com>) id 1VqdTS-0001Kl-Ds
 for pgsql-general@postgresql.org; Wed, 11 Dec 2013 06:40:46 +0000
Received: from hogranch.com ([75.101.82.47])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <pierce@hogranch.com>) id 1VqdTP-0004DY-5l
 for pgsql-general@postgresql.org; Wed, 11 Dec 2013 06:40:46 +0000
Received: from [192.168.0.2] (porker [192.168.0.2])
 by hogranch.com (8.11.6/8.11.6) with ESMTP id rBB6eXn03258
 for <pgsql-general@postgresql.org>; Tue, 10 Dec 2013 22:40:33 -0800
Message-ID: <52A808DF.3020902@hogranch.com>
Date: Tue, 10 Dec 2013 22:40:31 -0800
From: John R Pierce <pierce@hogranch.com>
User-Agent: Mozilla/5.0 (Windows NT 6.3; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.1.1
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Re: Case sensitivity
References: 
 <CALSLE1ND5tbXYwB=rbnbaTW4_nRCjr5uofK7nKxtN3M9PE42YQ@mail.gmail.com>
In-Reply-To: 
 <CALSLE1ND5tbXYwB=rbnbaTW4_nRCjr5uofK7nKxtN3M9PE42YQ@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-HawgScanner-Information: Please contact the ISP for more information
X-HawgScanner: Found to be clean
X-Pg-Spam-Score: -2.1 (--)
List-Archive: <http://archives.postgresql.org/pgsql-general>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-general.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@postgresql.org>
List-Post: <mailto:pgsql-general@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-general>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
X-Mailing-List: pgsql-general
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

On 12/10/2013 10:31 PM, Dev Kumkar wrote:
> I know about CITEXT data type, but what am looking for is if there any 
> parameter at database level which just makes the database case 
> insensitive.

there's nothing that will do that in postgres.

whats wrong with using CITEXT ?



-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general