On 13 Apr 2014, at 12:32pm, Tim Streater <[email protected]> wrote:

>> CREATE INDEX t1b ON t1(b) WHERE b=1;
> 
> I get no assertion fault but rather a syntax error here on "where".

Partial indexes were introduced in 3.8.0.  See the last section of

<http://sqlite.org/partialindex.html>

Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to