![](https://secure.gravatar.com/avatar/908c9abc72ab86111a153b11cb584f26.jpg?s=120&d=mm&r=g)
28 Dec
2017
28 Dec
'17
1:51 a.m.
On Wed, Dec 27, 2017 at 3:30 PM, Sergei Golubchik
Any plans to implement partial indexes? (https://www.postgresql.org/docs/10/static/indexes-partial.html)
No such plans at the moment. What do you you need them for?
I have used unique partial indexes to enforce business rules like "Active users must have a unique phone number, but there may be any number of inactive users with the same phone number" ``` create unique index ix_active_phones on users (phone) where active = true ; ``` -- Jared Beck • (607) 216-5373 • jared@jaredbeck.com