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  (Karel Zak <zakkr@zf.jcu.cz>)
Re: now() does not change within a transaction  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Следующее
От: Makarov Gera x8521
Дата:
Сообщение: Migrating Oracle to PostgreSQL