On 1/4/06, Robert Osowiecki <robson@xxxxxxxxx> wrote: > Apart from now() function, is there some kind of sequence that advances > with each transaction started? If not: is it possible to implement that > using sequences? > > Robson. > > it exists a transaction id called XID, you can't get it via sql though, you need to make a c function and invoke GetTopTransactionId() (or GetCurrentTransactionId() in versions prior to 8.0) -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)