How does the performance compare to using lower(varchar) vs citext? -----Original Message----- From: Scott Marlowe [mailto:scott.marlowe@xxxxxxxxx] Sent: Tuesday, August 24, 2010 12:11 PM To: Ozer, Pam Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: Case Insensitive Database On Tue, Aug 24, 2010 at 12:43 PM, Ozer, Pam <pozer@xxxxxxxxxxxxxx> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
