Book Contents

Book Index

Next Topic

Home

INTEGER (BIGINT)

Vertica supports the numeric data type INTEGER, a signed eight-byte (64-bit) data type.

Syntax

[ INTEGER | INT | BIGINT ]

Semantics

The difference between integer and bigint is in the way that vsql performs input and output. INTEGER is handled as a 32-bit data type and BIGINT is handled as a 64-bit data type.

Notes

The JDBC type INTEGER is 4-bytes, and is not supported by Vertica; use BIGINT instead.