Date: Wed, 11 Dec 2013 10:28:21 -0500
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-general@postgresql.org
Subject: Re: Case sensitivity
Message-ID: <20131211152821.GC35381@crankycanuck.ca>
References: 
 <CALSLE1ND5tbXYwB=rbnbaTW4_nRCjr5uofK7nKxtN3M9PE42YQ@mail.gmail.com>
 <52A808DF.3020902@hogranch.com>
 <CALSLE1O63G_=9usqiRyxyygbXNHKT-WPN_Ai5We8iiAGdiLzXQ@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CALSLE1O63G_=9usqiRyxyygbXNHKT-WPN_Ai5We8iiAGdiLzXQ@mail.gmail.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

On Wed, Dec 11, 2013 at 04:55:07PM +0530, Dev Kumkar wrote:
> creating database. I have been looking at other discussions and doesn't
> look like anything of that coming up soon that makes database case
> insensitive.

You could build lower() indexes on any column you want to search CI
and lower() all the input text during searches, in order to avoid any
work on the schema.  Bit of a kludge, though.

Best,

A


-- 
Andrew Sullivan
ajs@crankycanuck.ca


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