H. Features Introduced in Ingres 9.0 (Ingres 2006) : New Features for Application Developers : Support for New Data Types
 
Share this page                  
Support for New Data Types
Ingres 2006 supports the bigint and tinyint data types.
bigint
The bigint numeric data type stores 64-bit integers. The bigint data type is an implementation of the ANSI standard bigint. Integer8, Int8, and i8 are synonyms for this data type.
The int8 function converts the specified expression, which can be a c, char, varchar, nchar, nvarchar, text, float, money, decimal, integer1, smallint, to a 64-bit integer. Decimal and floating-point values are truncated. Numeric overflow occurs if the integer portion of a floating-point or decimal value is too large to be returned in the requested format.
tinyint
The tinyint numeric data type is a synonym for i1. Supported values are from -128 to +127.
For more information on new data types, see the SQL Reference Guide.