Re: [GENERAL] CURRENT_TIMESTAMP

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: [GENERAL] CURRENT_TIMESTAMP
Дата
Msg-id 200209231853.36530.josh@agliodbs.com
обсуждение исходный текст
Ответ на Re: [GENERAL] CURRENT_TIMESTAMP  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: [GENERAL] CURRENT_TIMESTAMP
Список pgsql-sql
Tom, Bruce,

> > A possible compromise is to dissociate now() and current_timestamp,
> > allowing the former to be start of transaction and the latter to be
> > start of client command.
>
> I was thinking 'transaction_timestamp' for the transaction start time, and
> current_timestamp for the statement start time.  I would equate now()
> with current_timestamp.

May I point out that this will break compatibility for those used to the
current behavior?


--
-Josh BerkusAglio Database SolutionsSan Francisco



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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] CURRENT_TIMESTAMP
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] CURRENT_TIMESTAMP