INT

On this page Carat arrow pointing down
Warning:
CockroachDB v1.0 is no longer supported as of November 10, 2018. For more details, refer to the Release Support Policy.

The INT data type stores 64-bit signed integers, that is, whole numbers from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.

Note:
To auto-generate globally unique integers, use the SERIAL data type.

Aliases

In CockroachDB, the following are aliases for INT:

  • SMALLINT
  • INTEGER
  • INT8
  • INT64
  • BIGINT

Syntax

A constant value of type INT can be entered as a numeric literal. For example: 42, -1234, or 0xCAFE.

Size

An INT column supports values up to 64 bits (8 bytes) in width, but the total storage size is likely to be larger due to CockroachDB metadata.

CockroachDB does not offer multiple integer types for different widths; instead, our compression ensures that smaller integers use less disk space than larger integers. However, you can use the BIT(n) type, with n from 1 to 64, to constrain integers based on their corresponding binary values. For example, BIT(5) would allow 31 because it corresponds to the five-digit binary integer 11111, but would not allow 32 because it corresponds to the six-digit binary integer 100000, which is 1 bit too long. See the example below for a demonstration.

Note:
BIT values are input and displayed in decimal format by default like all other integers, not in binary format. Also note that BIT is equivalent to BIT(1).

Examples

> CREATE TABLE ints (a INT PRIMARY KEY, b SMALLINT, c BIT(5));
CREATE TABLE
> SHOW COLUMNS FROM ints;
+-------+--------+-------+---------+-----------+
| Field |  Type  | Null  | Default |  Indices  |
+-------+--------+-------+---------+-----------+
| a     | INT    | false | NULL    | {primary} |
| b     | INT    | true  | NULL    | {}        |
| c     | BIT(5) | true  | NULL    | {}        |
+-------+--------+-------+---------+-----------+
(3 rows)
> INSERT INTO ints VALUES (1, 32, 32);
pq: bit string too long for type BIT(5) (column "c")
> INSERT INTO ints VALUES (1, 32, 31);
INSERT 1
> SELECT * FROM ints;
+---+----+----+
| a | b  | c  |
+---+----+----+
| 1 | 32 | 31 |
+---+----+----+
(1 row)

Supported Casting & Conversion

INT values can be cast to any of the following data types:

Type Details
DECIMAL ––
FLOAT Loses precision if the INT value is larger than 2^53 in magnitude
BOOL 0 converts to false; all other values convert to true
DATE Converts to days since the Unix epoch (Jan. 1, 1970)
TIMESTAMP Converts to seconds since the Unix epoch (Jan. 1, 1970). This is a CockroachDB experimental feature which may be changed without notice.
INTERVAL Converts to microseconds
STRING ––

See Also

Data Types


Yes No
On this page

Yes No