On 5/5/18, Deon Brewis <de...@outlook.com> wrote: > Is there a direct way to query how many rows are in a partial index? > > I know I can repeat the WHERE clause expression in the query, but this is > for a dynamically constructed index and knowing what the current "where" > clause is on the index has some race conditions attached. Solvable... but if > there is a direct way, I'd prefer that. Otherwise no big deal.
There is some unsupported trickery involving SQLITE_TESTCTRL_IMPOSTER, but extracting the WHERE clause from the sqlite_master table seems safer and easier. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users