Creating a case insensitive data type

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/