#986

Case-Insensitive Login

The login form searches by email regardless of letter case, and a plain index on email does not support that pattern. Create an index on the normalized email value used by login.

Speed this query up with an index
CREATE INDEX ix_users_lower_email ON users (lower(email))

Pelkkä CREATE/ALTER/DROP — lopussa ei tarvita SELECT-lausetta.

Kyselysi tulos näkyy tässä