Martijn van Oosterhout <kleptog(at)svana(dot)org> writes:
> Another option would be to create a new datatype 'itext' which works
> like text except it compares case insensetively. PostgreSQL is flexible
> like that. Here's something to get you started, see below for example.
> http://svana.org/kleptog/pgsql/type_itext.sql
> At the moment it uses SQL functions for the comparisons, for production
> you'd probably want to have them in C for performance.
I believe there is a C-coded type like this on gborg ("citext" is the
name I think).
regards, tom lane