E. Features Introduced in Ingres 9.3 : DBMS Server Enhancements : 64-bit Integer Sequences
 
Share this page                  
64-bit Integer Sequences
A sequence can be a 64-bit integer.
Support for 64-bit integer sequences affects the CREATE SEQUENCE statement syntax. A sequence can be created as a BIGINT, as well as an INTEGER or DECIMAL data type. For example:
CREATE SEQUENCE bigseq1 AS BIGINT
You must upgrade to take advantage of the 64-bit integer sequence. Upgrading changes the layout of the iisequences system catalog.
For more information, see the SQL Reference Guide.