Pam Ozer
Обсуждение: Case Insensitive Database
I currently have a mysql database that is case insensitive. Is it possible to set up a case insensitive database in PostgressQl? So far it doesn’t look like it. And if it is possible what are the variables I need to set?
Thanks
On Tue, Aug 24, 2010 at 12:43 PM, Ozer, Pam <pozer@automotive.com> wrote: > I currently have a mysql database that is case insensitive. Is it possible > to set up a case insensitive database in PostgressQl? So far it doesn’t > look like it. And if it is possible what are the variables I need to set? You can use the contrib module for citext types. -- To understand recursion, one must first understand recursion.
How does the performance compare to using lower(varchar) vs citext? -----Original Message----- From: Scott Marlowe [mailto:scott.marlowe@gmail.com] Sent: Tuesday, August 24, 2010 12:11 PM To: Ozer, Pam Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Case Insensitive Database On Tue, Aug 24, 2010 at 12:43 PM, Ozer, Pam <pozer@automotive.com> wrote: > I currently have a mysql database that is case insensitive. Is it possible > to set up a case insensitive database in PostgressQl? So far it doesn't > look like it. And if it is possible what are the variables I need to set? You can use the contrib module for citext types. -- To understand recursion, one must first understand recursion.
I'm not sure. I've always used lower() with indexes on lower() for myself. On Tue, Aug 24, 2010 at 3:20 PM, Ozer, Pam <pozer@automotive.com> wrote: > How does the performance compare to using lower(varchar) vs citext? > > -----Original Message----- > From: Scott Marlowe [mailto:scott.marlowe@gmail.com] > Sent: Tuesday, August 24, 2010 12:11 PM > To: Ozer, Pam > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Case Insensitive Database > > On Tue, Aug 24, 2010 at 12:43 PM, Ozer, Pam <pozer@automotive.com> wrote: >> I currently have a mysql database that is case insensitive. Is it possible >> to set up a case insensitive database in PostgressQl? So far it doesn't >> look like it. And if it is possible what are the variables I need to set? > > You can use the contrib module for citext types. > > -- > To understand recursion, one must first understand recursion. > -- To understand recursion, one must first understand recursion.
Okay thanks. I can play around with it. -----Original Message----- From: Scott Marlowe [mailto:scott.marlowe@gmail.com] Sent: Tuesday, August 24, 2010 2:26 PM To: Ozer, Pam Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Case Insensitive Database I'm not sure. I've always used lower() with indexes on lower() for myself. On Tue, Aug 24, 2010 at 3:20 PM, Ozer, Pam <pozer@automotive.com> wrote: > How does the performance compare to using lower(varchar) vs citext? > > -----Original Message----- > From: Scott Marlowe [mailto:scott.marlowe@gmail.com] > Sent: Tuesday, August 24, 2010 12:11 PM > To: Ozer, Pam > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Case Insensitive Database > > On Tue, Aug 24, 2010 at 12:43 PM, Ozer, Pam <pozer@automotive.com> wrote: >> I currently have a mysql database that is case insensitive. Is it possible >> to set up a case insensitive database in PostgressQl? So far it doesn't >> look like it. And if it is possible what are the variables I need to set? > > You can use the contrib module for citext types. > > -- > To understand recursion, one must first understand recursion. > -- To understand recursion, one must first understand recursion.