Re: Is there hidden timestamp column ?

lclee@nntp.best.com (Lin-Chuan Lee) wrote: :Is there a timestamp column that can be queried/fetched :like the rowid column ??? The lack of such a column is one of the major remaining problems with Informix databases. Of course it should *NOT* be hidden, but be a special datatype. I hope someone will do this for the Universal Server. (For those who are not 100% clear on what a timestamp is it's a type of serial that starts out at 1 (or 0) when a row is inserted and is increased by 1 every time an update is done to that same row. It's very usefull to avoid the need of locking rows in an optimistic locking strategy.) Nils.Myklebust@ccmail.telemax.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company