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 assignments). 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;

RDM also supports unsigned integers by adding the UNSIGNED qualifier, like UNSIGNED INTEGER.

Other representations of the above types can be written as: INT8, UINT8, INT16, UINT16, INT32, UINT32, INT64 and UINT64.

For more information, see Integer Types.