# INTEGER data type

The INTEGER data type stores whole numbers that range from -2,147,483,647 to 2,147,483,647 for 9 or 10 digits of precision.

The number 2,147,483,648 is a reserved value and cannot be used. The INTEGER value is stored as a signed binary integer and is typically used to store counts, quantities, and so on.

Arithmetic
operations and sort comparisons are performed more efficiently on
integer data than on float or decimal data. INTEGER columns, however,
cannot store absolute values beyond (2^{31}-1). If a data
value lies outside the numeric range of INTEGER, the database server
does not store the value.

INTEGER data types require 4 bytes of storage per value.