same result using ORDER BY cast(lati10 as real), cast(longi as real) as with ORDER BY lati10+0, longi+0 which was already tried 380|41.2|9.37497676257462 380|41.2|16.6342872848924 792|41.2|43.2255548289229 860|41.2|66.7126410609169 408|41.2|129.727571723508 840|41.2|-73.970001 840|41.2|-73.964172