[rt-users] bug in watcher search for Postgres

[Vivek Khera]

>>>>> "RC" == Rafael Corvalan <Rafael.Corvalan at linkvest.com> writes:

RC> If someone in the list is a postgres specialist, maybe he could tell us
RC> if there is a way to configure a column table to do case insensitive
RC> searches...

There is no such mechanism in PostgreSQL as of 7.1.x.  I doubt there
will be, other than using triggers or some funkyness.

You can however, use functions like lower() in unique indexes to
prevent duplicates.  Basically, it is a PITA with email addresses
since most of the time they are case-insensitive, but technically the
local address part (left of the @) is not supposed to be altered by
any MTA since it is truly locally interpreted.

I say screw it and store all email addresses lower-cased.