Alan McDonald wrote:

>>Hello,
>>
>>I am designing big database, where will be one generator that will
>>generate values for primary keys of all tables (so all records in all
>>tables will be unique). Integer is too small for primary key I decided
>>to use NUMERIC(15,1). Will it slow down performace? What is
>>generator's max size? What type to use?
>>
>>
>>
>
>Use a BIGINT or INT64 you get
>9,223,372,036,854,775,807
>positive value
>You also get the same in negative values. You can set the generator
>to -9,223,372,036,854,775,807 to start if you want.
>Big enough?
>
>But why on earth do you wnat to use only one generator?
>Alan
>
>

How many INTEGER generators will be enough to cover one NUMERIC (18,0)?
Niki

>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>

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