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

From Martijn van Oosterhout
Subject Re: Creating a case insensitive data type
Date
Msg-id 20060526185005.GH27513@svana.org
Whole thread Raw
In response to Creating a case insensitive data type  (Dave <david.majnemer@gmail.com>)
List pgsql-hackers
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.

pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: Inefficient bytea escaping?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: max(*)