Re: [SQL] [GENERAL] CURRENT_TIMESTAMP

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB SD
Тема Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
Дата
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4961EAB@m0114.s-mxs.net
обсуждение исходный текст
Ответы Re: [SQL] [GENERAL] CURRENT_TIMESTAMP  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> > I'd give you the first and third of those.  As Andrew noted, the
> > argument that "it's more standard-compliant" is not very solid.
>
> The standard doesn't say anything about transaction in this regard.

Yes, it sais statement.

Note also, that a typical SELECT only session would not advance
CURRENT_TIMESTAMP at all in the typical "autocommit off" mode that
the Spec is all about.

> What do others think?

I liked your proposal to advance CURRENT_TIMESTAMP at each statement start.
(It would not advance inside a stored procedure).

Andreas


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

Предыдущее
От: "Shridhar Daithankar"
Дата:
Сообщение: Re: Large databases, performance
Следующее
От: Steve King
Дата:
Сообщение: Bad rules