Glossary: PostgreSQL Beyond the Basics
Expression index
Also written: index on an expression, lower(email) index
An index built on a function's result, such as `(lower(email))`. The query's WHERE must use the same expression for the planner to use it.