Re: Keys larger than 2 Billion

Mike Segel wrote: > > Now I am confused. (Yes, that does happen occasionally when I sober > up. ;-) Are you trying to suggest that you are currently sober? > A serial field by definition creates a unique index on the > serial column. Are you suggesting to create the table, then > either alter the index or drop the index on a serial column? This was a suggestion, but the general consensus was to use a DEC key. > Is that possible? Yes. How's the head Mike? Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+