Re: oracle sequence numbers

On Thu, 16 Jan 2003 07:14:21 GMT, Joel Meulenberg <my_first_and_last_name_with_no_punctuation_at_attbi.com> wrote:

>I would not recommend using a timestamp as a surrogate key. Just think
>about what happens when you want to insert two rows within the same
>second (or whatever the smallest grain of time is for your DBMS (or even
>your own homegrown time datatype for that matter)).

Hmmm ... DB2 granularity is in microseconds ... good enough for me.

However, I agree that this is not appropriate for all datasources. It's always important to exercise common sense once in a while. <g>

Bob Hairgrove
rhairgroveNoSpam_at_Pleasebigfoot.com Received on Thu Jan 16 2003 - 20:32:30 CET