Re: Keys larger than 2 Billion

--- On Tue, 17 Sep 1996 16:36:00 GMT Nils Myklebust wrote: }"Mark D. Stock" <marks@west.co.za> wrote: } }:Leonid Belov wrote: }:> }:> Serial key will be unique across the whole table regardless of what you use }:> as primary key - single column or composite key. If you want to have }:> so much rows you _cannot_ use serial column } }:Weeeell, you can drop the system index and create a composite index with the }:serial column. } }Actually a very elegant solution, if the serial datatype keeps going }round robin. (You might want to test that, or check with Informix.) A }simple time field in addition would make it unique. } Serial does wrap around. However, if the original poster needs that much data, a serial field is highly unlikely to find an unused value as soon as it hits the 2 billion limit (remember, serial is unique!), so serial + time stamps is not a viable solution. ciao, marco ____________________________________________________________________________ rem radioterapia, which I immeritately manage, seldom agrees with what I say marco greco (Catania, Italy) Work: marcog@ctonline.it rem radioterapia 39 95 447828 fax 446558 (was mar.greco@agora.stm.it) Achea 39 95 503117