Can case-insensitive collation help here?
On Wed, Dec 11, 2013 at 4:55 PM, Dev Kumkar <devdas.kumkar@xxxxxxxxx> wrote:
regards...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.
On Wed, Dec 11, 2013 at 12:10 PM, John R Pierce <pierce@xxxxxxxxxxxx> wrote:
On 12/10/2013 10:31 PM, Dev Kumkar wrote:there's nothing that will do that in postgres.
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.
whats wrong with using CITEXT ?
