Query help

Phil Mayers p.mayers at imperial.ac.uk
Wed Oct 10 17:03:42 CEST 2012

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.


select sum() / 1000000

select quota / 1000000

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

More information about the Freeradius-Users mailing list