2016-04-14 19:49 GMT+02:00 Dominique Devienne <ddevienne at gmail.com>:
> On Thu, Apr 14, 2016 at 7:48 PM, Cecil Westerhof <cldwesterhof at gmail.com> > wrote: > > > If I would have a table where a lot of values are NULL. Would it be > > possible to exclude those records from the index? I would only search > for a > > certain value not for NULL. Or is it the default that they are excluded? > > > https://www.sqlite.org/partialindex.html ?OK, I have to exclude it myself. (Is the sane option I think.) I have to study the page: it has the solution of another problem I was contemplating. From active records the description should be UNIQUE, but it is not necessary for inactive records. I saw that this page has the solution. :-) -- Cecil Westerhof