On 4 Sep 2017, at 12:00am, Bart Smissaert <bart.smissa...@gmail.com> wrote:

> It looks this example doesn't work:
> 
> SELECT sum(pgsize-unused)/sum(pgsize) FROM dbstat WHERE name='xyz'

What is the output of

SELECT typeof(pgsize), typeof(unused) FROM dbstat WHERE name='xyz' LIMIT 1

?

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to