Обсуждение: 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.