From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-general@postgresql.org
Subject: Re: Case sensitivity
Date: Wed, 11 Dec 2013 10:28:21 -0500
Message-ID: <20131211152821.GC35381@crankycanuck.ca> (raw)
In-Reply-To: <CALSLE1O63G_=9usqiRyxyygbXNHKT-WPN_Ai5We8iiAGdiLzXQ@mail.gmail.com>
References: <CALSLE1ND5tbXYwB=rbnbaTW4_nRCjr5uofK7nKxtN3M9PE42YQ@mail.gmail.com>
<52A808DF.3020902@hogranch.com>
<CALSLE1O63G_=9usqiRyxyygbXNHKT-WPN_Ai5We8iiAGdiLzXQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: ajs@crankycanuck.ca
Subject: Re: Case sensitivity
In-Reply-To: <20131211152821.GC35381@crankycanuck.ca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox