Subject Want to use 64 bit integers
Author Nols Smit
Hi,

How do I declare 64 bit integers in FireBird. I want to use it as the key value of a certain table.

Will this syntax do?

CREATE DOMAIN ID_INTEGER64BIT AS
NUMERIC(18,0)
NOT NULL

It seems a 64 bit key value may run into Zillions (-2^63..2^63-1)

Are there other considerations I must take into account?

Regards.


[Non-text portions of this message have been removed]