I would like to request an improvement to the PostgreSQL documentation, specifically in the sections "11.6. Unique Indexes" and "11.8. Partial Indexes."
Currently, the documentation does not provide information on how to create unique partial indexes. Unique partial indexes are valuable for enforcing uniqueness of a column's value over a subset of a table
11.8 discusses this in detail including an example. Maybe should add a forward reference from 11.6 though.