Re: time stops within transaction
От | Peter Eisentraut |
---|---|
Тема | Re: time stops within transaction |
Дата | |
Msg-id | Pine.LNX.4.21.0010181808020.3228-100000@peter.localdomain обсуждение исходный текст |
Ответ на | Re: time stops within transaction (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: time stops within transaction
|
Список | pgsql-hackers |
Tom Lane writes: > Peter Eisentraut <peter_e@gmx.net> writes: > > Tom Lane writes: > >> That is what now() is defined to return: transaction start time. > > > Then CURRENT_TIMESTAMP is in violation of SQL. > > Au contraire, if it did not behave that way it would violate the spec. > See SQL92 6.8 general rule 3: > > 3) If an SQL-statement generally contains more than one reference > to one or more <datetime value function>s, then all such ref- > erences are effectively evaluated simultaneously. The time of > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > evaluation of the <datetime value function> during the execution > of the SQL-statement is implementation-dependent. statement != transaction -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
В списке pgsql-hackers по дате отправления: