Re: Case sensitivity

Martijn van Oosterhout <kleptog@svana.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