Re: Unique transaction ID

On 1/4/06, Robert Osowiecki <robson@cavern.pl> 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 ;)