This post presents a SQL puzzle drawn from a real-world use case to show the power of advanced RDBMS features such as partial indexes and expression indexes. It uses a PostgreSQL table named users, defined with an id serial primary key, an email column defaulting to NULL, and a name column, then asks what the difference is between two indexes created on that table.
