2010/6/11 Mike Christensen <m...@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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
