now() does not change within a transaction - Mailing list pgsql-sql

From Christoph Haller
Subject now() does not change within a transaction
Date
Msg-id 200204181204.OAA11703@rodos
Whole thread Raw
Responses Re: now() does not change within a transaction  (Karel Zak <zakkr@zf.jcu.cz>)
Re: now() does not change within a transaction  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-sql
Hi pgsql-sql list, 
I did some testing around tables using a column 
timestamp with time zone not null default now(). 
I have noticed a valuable feature: 
As long as being inside a transaction initiated by 
begin; 
the return value of the now() function does not change. 
Is this intended - as written in the documentation? 
Can I rely on it, so future releases of PostgreSQL 
will act the same. 
Regards, Christoph 


pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Next
From: Makarov Gera x8521
Date:
Subject: Migrating Oracle to PostgreSQL