28 Dec
2017
28 Dec
'17
12:51 a.m.
On Wed, Dec 27, 2017 at 3:30 PM, Sergei Golubchik <serg@mariadb.org> wrote:
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