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