Neil Conway wrote:
> Bruce Momjian wrote:
> > Peter Eisentraut wrote:
> >> The most common complaint that I recall is that current_timestamp 
> >> returns the transaction timestamp rather than the statement timestamp, 
> >> which is what many expect.  How does your patch address that?
> > 
> > No, we believe the standard requires it.
> My copy of SQL 200n has the following to say:
> Annex C, paragraph 16:
>      "The time of evaluation of the CURRENT_DATE, CURRENT_TIME, and
>      CURRENT_TIMESTAMP functions during the execution of an
>      SQL-statement is implementation-dependent."
> 6.31, <datetime value function>:
>      (1) The <datetime value function>s CURRENT_DATE, CURRENT_TIME,
>      and CURRENT_TIMESTAMP respectively return the current date,
>      current time, and current timestamp; the time and timestamp values
>      are returned with time zone displacement equal to the current
>      default time zone displacement of the SQL-session. [...]
>      (2) Let S be an <SQL procedure statement> that is not generally
>      contained in a <triggered action>. All <datetime value function>s
>      that are contained in <value expression>s that are generally
>      contained, without an intervening <routine invocation> whose subject
>      routines do not include an SQL function, either in S without an
>      intervening <SQL procedure statement> or in an <SQL procedure
>      statement> contained in the <triggered action> of a trigger
>      activated as a consequence of executing S, are effectively evaluated
>      simultaneously. The time of evaluation of a <datetime value
>      function> during the execution of S and its activated triggers is
>      implementation-dependent.

OK, so we just decided transaction timestamp is the most logical value
for CURRENT_TIMESTAMP.  Anyway, this might mean we should have
transaction_timestamp for completeness.  Not sure.

  Bruce Momjian
  SRA OSS, Inc.

  + If your life is a hard drive, Christ can be your backup. +

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to