Integer Data Types
Go Up to Defining Numeric Data Types
Integers are whole numbers. InterBase supports two integer data types:
SMALLINT is a signed short integer with a range from –32,768 to 32,767.
INTEGER is a signed long integer with a range from –2,147,483,648 to 2,147,483,647. Both are exact numerics.
The next two statements create domains with the
INTEGER data types:
CREATE DOMAIN EMPNO AS SMALLINT; CREATE DOMAIN CUSTNO AS INTEGER CHECK (VALUE > 99999);
You can perform the following operations on the integer data types:
- Comparisons using the standard relational operators (=, <, >, >=, <=). Other operators such as
STARTING WITH, and
LIKEperform string comparisons on numeric values.
- Arithmetic operations. The standard arithmetic operators determine the sum, difference, product, or dividend of two or more integers.
- Conversions. When performing arithmetic operations that involve mixed data types, InterBase automatically converts between
CHARdata types. For operations that involve comparisons of numeric data with other data types, InterBase first converts the data to a numeric type, then performs the arithmetic operation or comparison.
- Sorts. By default, a query retrieves rows in the exact order that it finds them in the table, which is likely to be unordered. You can sort rows using the
ORDER BYclause of a
SELECTstatement in descending or ascending order.