What is a function-based / expression index?

Answer preview

An expression (function-based) index stores the result of an expression rather than the raw column, e.g. lower(email). It is how you make an otherwise non-sargable predicate indexable — the query must use the same expression for the planner to match it.…