Integer

Integer types include tinyint, smallint, integer, and bigint. Integer constants are contained in the smallest integer type that can hold the value but no smaller than a smallint (RDM SQL automatically handles mixed size integer assignements).. If the precision of an integer constant is greater than that for a bigint (int64_t) then the value is returned as a decimal value. Integer constants are formed as follows.

integer:
                [+ | -]digit...

1021
-52
select * from mytypes where myage >= 50 and myatoms < 7574601843000;
update mytypes set mygadgets = -1 where myage < 6;