Re: current_timestamp after queries

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: current_timestamp after queries
Дата
Msg-id 21610.1033399799@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: current_timestamp after queries  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Need Oracle 9 tester. was Re: current_timestamp after queries  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Yes, timeofday() will work, but it can change during the statement, right?

For what he was doing, it seemed perfectly acceptable.

This comes back to the point I've been making during the pghackers
discussion: start-of-transaction time has clear uses, and
exact-current-time has clear uses, but it's not nearly as obvious
why you'd need start-of-statement time in preference to either of
the others.

            regards, tom lane

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] current_timestamp after queries
Следующее
От: Bruce Momjian
Дата:
Сообщение: Need Oracle 9 tester. was Re: current_timestamp after queries