Comment by ubertaco

Or they want to allow for case-insensitivity of some data, like for example email addresses on login forms.

As much as postgres is overall better than MySQL in so many ways, it's still ridiculously difficult to set things up such that

    SELECT id FROM users WHERE email='[email protected]' 

returns the same result as

    SELECT id FROM users WHERE email='[email protected]'