now() does not change within a transaction

Поиск
Список
Период
Сортировка
От Christoph Haller
Тема now() does not change within a transaction
Дата
Msg-id 200204181204.OAA11703@rodos
обсуждение исходный текст
Ответы Re: now() does not change within a transaction
Re: now() does not change within a transaction
Список 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 по дате отправления: