Can case-insensitive collation help here?
On Wed, Dec 11, 2013 at 4:55 PM, Dev Kumkar <devdas.kum...@gmail.com> wrote: > Thanks John. > > Yes CITEXT would work, the only thing its needs DDL changes across and > hence was looking for any such global database parameter setting while > 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. > > regards... > > > On Wed, Dec 11, 2013 at 12:10 PM, John R Pierce <pie...@hogranch.com>wrote: > >> 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 ? >> >>
