Re: oracle sequence numbers
From: Tibor Karaszi <tibor_not_pressed_ham_.karaszi_at_cornerstone.se>
Date: Thu, 16 Jan 2003 20:35:00 GMT
Message-ID: <UHEV9.6590$LY2.385902_at_newsc.telia.net>
Date: Thu, 16 Jan 2003 20:35:00 GMT
Message-ID: <UHEV9.6590$LY2.385902_at_newsc.telia.net>
Pablo might have referred to the "timestamp" datatype in MS/Sybase SQL Server. This is really a binary type of counter which changes to a new database-wide unique value each time the row is updated. It can be used to implement optimistic concurrency.
-- Tibor Karaszi "Bob Hairgrove" <rhairgroveNoSpam_at_Pleasebigfoot.com> wrote in message news:3e2707f5.1213124_at_news.webshuttle.ch...Received on Thu Jan 16 2003 - 21:35:00 CET
> On Thu, 16 Jan 2003 09:40:02 -0600, Pablo Sanchez <pablo_at_dev.null>
> wrote:
>
> >Even worst, some DBMS update the timestamp any time the row is
> >affected since the timestamp data type is used for other purposes.
>
> Huh??
>
> Once you have written a value to a column, it should stay the same
> (unless you have a trigger implemented to update it)...
>
>
> Bob Hairgrove
> rhairgroveNoSpam_at_Pleasebigfoot.com