Note that Postgres supports functional indexes, and the case in the post (a `lower(column)=`-clause not being able to utilise the column's index) is the example used in the documentation: https://www.postgresql.org/docs/current/static/indexes-expre...