In postgres, it's possible to create an index based on a function:CREATE INDEX lower_userid ON dbmail_users (lower(userid)); At that point the query would take about the same amount of time and userids can stay in different cases.
That is very cool and one more reason why I prefer postgres. However, I didn't find that as an index in the table definition.Did I not see it because I didn't know what I was looking for, or is it not exactly there?
