Coming soon — this article is being prepared. Below are its question, intended outcome, and place in the story.
The question
How can you restrict an index using a predicate or expression?
What we will work through
Restrict an index using a predicate or expression.
Before you begin
Previously covered: B-tree indexes; EXPLAIN and EXPLAIN ANALYZE.