> In a transaction until you commit your transaction through a jdbc > connection, each time you use the Current_timestamp (or 'now'), the > timestamps is always the same, and when your transaction is very long you > have undesirable effect.
This is not a bug, but the behavior required by SQL9x afaicr. There is another function (timeofday()?) which returns the current clock time. hth - Thomas ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])