Den Tue, Dec 07, 2004 at 03:13:04AM -0000 eller der omkring skrev Andrew - Supernews: > On 2004-12-07, Stephen Frost <[EMAIL PROTECTED]> wrote: > > Is there a way to say "just take the value of this function at the start > > of the transaction and then have it be constant" in a query? > > Why not use CURRENT_TIMESTAMP, etc., which do exactly that? >
Because when using transactions, CURRENT_TIMESTAMP does not advance, but is fixed to time of session start /Per ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
