Re: [Maria-developers] Partial indexes?

2017-12-28 Thread Jared Beck
On Thu, Dec 28, 2017 at 9:34 AM, Sergei Golubchik 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 Ser

Re: [Maria-developers] Partial indexes?

2017-12-28 Thread Sergei Golubchik
Hi, Jared! On Dec 27, Jared Beck wrote: > On Wed, Dec 27, 2017 at 3:30 PM, Sergei Golubchik 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