On Wed, Dec 27, 2017 at 3:30 PM, Sergei Golubchik <[email protected]> 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 • [email protected] _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
