maria-developers team mailing list archive

[Jared Beck <jared@xxxxxxxxxxxxx>]

On Wed, Dec 27, 2017 at 3:30 PM, Sergei Golubchik <serg@xxxxxxxxxxx> 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@xxxxxxxxxxxxx