Re: [GENERAL] Unique transaction ID

2006-01-04 Thread Robert Osowiecki
Jaime Casanova napisaƂ(a): 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) I've read a little about problems with overlapping XID and how they were

[GENERAL] Unique transaction ID

2006-01-04 Thread Robert Osowiecki
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. ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please se

Re: [GENERAL] Cast to integer

2005-10-06 Thread Robert Osowiecki
A. Kretschmer wrote: am 05.10.2005, um 15:08:33 +0200 mailte Robert Osowiecki folgendes: Hello! Anyone could explain to me, why cast(3.33 to int) works (from float, I suppose) but cast('3.33' to int) (from text) does not? And what if I create a cast for that: is it possibly

[GENERAL] Cast to integer

2005-10-05 Thread Robert Osowiecki
Hello! Anyone could explain to me, why cast(3.33 to int) works (from float, I suppose) but cast('3.33' to int) (from text) does not? And what if I create a cast for that: is it possibly dangerous? Regards, Robert. ---(end of broadcast)--- TI