----- Original Message -----
From: "Claudio Valderrama C." <cvalde@...>
Newsgroups: egroups.ib-support
To: <ib-support@yahoogroups.com>
Sent: Friday, January 25, 2002 3:46 PM
Subject: Re: [ib-support] int64 (numeric(18,0)) 64-bit numeric range

[SNIP ...]

> > I need 64-bit for some kind of unique ID generation.
>
> Numeric will do with precision greater than 9; the full range is
available,
> but we do not handle unsigned quantities, so your values above 2^63-1 will
> be seen as negative values in a query.

But with a max of length of 18 digits using NUMERIC(18,0), it's impossible
to
even have a positive value of 2^60.

How can we have the full positive range of 2^63-1 (which requires 19 decimal
digits) ?
Unless of course, there's some way of creating a NUMERIC(19,0) field.

Thanks!

Regards
Kenneth