Creating a case insensitive data type - Mailing list pgsql-hackers

From Dave
Subject Creating a case insensitive data type
Date
Msg-id 44764A99.8030606@gmail.com
Whole thread Raw
Responses Re: Creating a case insensitive data type
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: LIKE, leading percent, bind parameters and indexes
Next
From: Tom Lane
Date:
Subject: Re: Inefficient bytea escaping?