Re: Case sensitivity - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Case sensitivity
Date
Msg-id 20131211152821.GC35381@crankycanuck.ca
Whole thread Raw
In response to Re: Case sensitivity  (Dev Kumkar <devdas.kumkar@gmail.com>)
Responses Re: Case sensitivity  (Dev Kumkar <devdas.kumkar@gmail.com>)
List pgsql-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


pgsql-general by date:

Previous
From: Dev Kumkar
Date:
Subject: Re: Case sensitivity
Next
From: salah jubeh
Date:
Subject: Re: Convert table to view 9.1