2010/6/11 Mike Christensen <mike@kitchenpc.com>:
> Yea this is a valid point. It's very possible my design won't work
> for the long term, and at some point I'll have to store the email name
> exactly as it was entered, and allow the lookup logic to be case
> insensitive with a lowercase index. However, I think the way I have
> it now should not break any known email server heh.
Instead of mangling data when you store it, mangle it later when you
retrieve it. with a functional index on the column, you get the
comparison data stored in an index, ready to go.
Performance test the index:
create test_index on table (lower(fieldname));
versus storing the emails in lower case.