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?



Oops,

CURRENT_TIMESTAMP *does* advance from transaction to transaction. As you can
see from my previous mail, I thought it was fixed to the time of session
start.

CURRENT_TIMESTAMP is fine for me then and I will not use
timeofday()::timestamptz

/Per


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to