Please don't post HTML to the mailing list - it makes quoting difficult...
From: "Daniel Åkerud" <zilch(at)home(dot)se>
If I do
BEGIN
UPDATE some_session set time_stop = CURRENT_TIMESTAMP
UPDATE another_session set time_start = CURRENT_TIMESTAMP
END
Is there any chance the current_timestamp will be different?
=reply=
If you try your example by hand (with a suitable pause) you'll see
CURRENT_TIMESTAMP and the now() function return the time at the start of the
transaction. You use timeofday() IIRC to get the "real" current time.
HTH
- Richard Huxton