Martijn van Oosterhout <kleptog@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
