Обсуждение: Creating a case insensitive data type
could CREATE TYPE be used to make a case insensitive version of varchar? So that doing something like LOWER(username) = 'joe' could just be done like username = 'joe' ? I want to try to avoid using CREATE TYPE with C extensions and using a new operator all over the place is not an option... How could I do this? Can I accomplish this via another method? -Dave
On Thu, May 25, 2006 at 08:23:53PM -0400, Dave wrote: > could CREATE TYPE be used to make a case insensitive version of varchar? > So that doing something like LOWER(username) = 'joe' could just be done > like username = 'joe' ? > > I want to try to avoid using CREATE TYPE with C extensions and using a > new operator all over the place is not an option... How could I do this? > Can I accomplish this via another method? Try this: http://gborg.postgresql.org/project/citext/projdisplay.php Have a nice day, -- Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to litigate.