Subject Re: [firebird-support] Generic StoredProc for returning generator value
Author Mahesh Ishwar
Thanx for the clarification Paul.


Paul Vinkenoog <paul@...> wrote:
Hi Mahesh,

> A generator generate values from -(2^64) to (2^64)-1.

This is an error in some docs. The value is a signed 64-bit integer,
and can therefore range from -(2^63) .. (2^63)-1

> This range of numbers can't be accomodated in INTEGER. U can use
> Numeric(18). It works fine. As for pitfalls, as of now I can see
> anything.

Except maybe that some 64-bit values need 19 positions. The range,
when written out, is:

-9,223,372,036,854,775,808 through 9,223,372,036,854,775,807

Internally, this is not a problem: an INT64 is used. Only if your app
- or your data access components - depend on the declared maximum
number of positions, you could run into trouble. But even then, this
would happen only if the generator values became really really big.

Paul Vinkenoog

Yahoo! Groups SponsorADVERTISEMENT

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Yahoo! Plus - For a better Internet experience

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