Need timestamp function that will change within a transaction

Поиск
Список
Период
Сортировка
От D. Dante Lorenso
Тема Need timestamp function that will change within a transaction
Дата
Msg-id 482B43FA.1020200@lorenso.com
обсуждение исходный текст
Ответы Re: Need timestamp function that will change within a transaction
Re: Need timestamp function that will change within a transaction
Список pgsql-general
I'd like to find a timestamp function that WILL change within a transaction.

This function will return to me a 15 digit BIGINT number in base10:

   SELECT FLOOR(EXTRACT(EPOCH FROM NOW()) * 100000)::bigint;

The problem is that NOW() does not change within a transaction and so I
keep getting the same value.  Is there a function that will return a
timestamp that is NOT consistent within a transaction?

-- Dante

В списке pgsql-general по дате отправления:

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: rounding problems
Следующее
От: Steve Atkins
Дата:
Сообщение: Re: Need timestamp function that will change within a transaction