Re: Timestamp Column. -Reply

In article <6i8aik$3eo$1@news.xmission.com>, Robert Wines <Robert_Wines@ama-assn.org> writes > >I would not recommend using datetime as a timestamp. Given the speed >of SMP systems it is possible that someone can submit a record during >.001 and someone else submit a record at .0019. > >I would suggest you use an integer, start a transaction that locks the >row, compares the integer, make whatever updates you need then >increment the integer and release the lock. > i.e. a serial field!! >robert_wines @ ama-assn.org -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care