On 13 Apr 2014, at 12:32pm, Tim Streater <t...@clothears.org.uk> 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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to