Both integer.

RBS

On Mon, Sep 4, 2017 at 12:50 AM, Simon Slavin <[email protected]> wrote:

>
>
> On 4 Sep 2017, at 12:00am, Bart Smissaert <[email protected]>
> 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
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to