Query help

[Phil Mayers]

On 10/10/12 15:25, Jonathan Bastin wrote:

> To me it looks like the value is wrapping. Is this due to that even the
> interpreter in the site config file is 32-bit only. If this is the case I
> presume my only resort it perl. If this is the case could someone help me
> convert this?

You could divide by some large factor inside the SQL database, which is 
likely using 64-bit or arbitrary precision internally.

e.g.

select sum() / 1000000

select quota / 1000000

...to convert to megabytes, and then compare like that.