← Back to team overview

maria-developers team mailing list archive

Re: Partial indexes?


On Thu, Dec 28, 2017 at 9:34 AM, Sergei Golubchik <serg@xxxxxxxxxxx> wrote:
> In MariaDB (and in SQL standard) the way to achieve that
> would be to use a nullable column for active, and mark inactive users
> with NULL. Then you can create a unique index on (phone,active).

That is a neat trick, thanks James and Sergei!

Jared Beck • (607) 216-5373 • jared@xxxxxxxxxxxxx

Follow ups