[sqlite] Exclude NULL from index

2016-04-14 Thread Cecil Westerhof 
2016-04-14 19:49 GMT+02:00 Dominique Devienne :

> On Thu, Apr 14, 2016 at 7:48 PM, Cecil Westerhof 
> 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

[sqlite] Exclude NULL from index

2016-04-14 Thread Dominique Devienne 
On Thu, Apr 14, 2016 at 7:48 PM, Cecil Westerhof 
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

[sqlite] Exclude NULL from index

2016-04-14 Thread Cecil Westerhof 
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?

-- 
Cecil Westerhof