It looks this example doesn't work: SELECT sum(pgsize-unused)/sum(pgsize) FROM dbstat WHERE name='xyz'
I thinks it should be something like this: SELECT cast(sum(pgsize-unused) as real) / cast(sum(pgsize) as real) FROM dbstat WHERE name='xyz' RBS _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users