Re: [HACKERS] Creating a case insensitive data type

2006-05-26 Thread Martijn van Oosterhout
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

[HACKERS] Creating a case insensitive data type

2006-05-26 Thread Dave
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... Ho