agora inbox for pgsql-docs@postgresql.org
help / color / mirror / Atom feedFrom: Tom Lane <tgl@sss.pgh.pa.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: petermittere@gmail.com
Cc: pgsql-docs@lists.postgresql.org
Subject: Re: please define 'statement' in the glossary
Date: Sun, 13 Jul 2025 17:56:53 -0400
Message-ID: <458204.1752443813@sss.pgh.pa.us> (raw)
In-Reply-To: <456003.1752442676@sss.pgh.pa.us>
References: <175223006802.3157505.14764328206246105568@wrigleys.postgresql.org>
<15139c5d218754350e4870062f90ff0e85490290.camel@cybertec.at>
<270191.1752420426@sss.pgh.pa.us>
<097e693ea6cc3541cbcd72c915d7d492c26930c0.camel@cybertec.at>
<456003.1752442676@sss.pgh.pa.us>
... so concretely, about like this?
regards, tom lane
Attachments:
[text/x-diff] v1-docs-clarify-current-timestamp-functions.patch (1.3K, ../458204.1752443813@sss.pgh.pa.us/2-v1-docs-clarify-current-timestamp-functions.patch)
download | inline diff:
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 6b327d4fd81..ed30dbe7ccd 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -11244,13 +11244,13 @@ now()
<function>CURRENT_TIMESTAMP</function>, but is named to clearly reflect
what it returns.
<function>statement_timestamp()</function> returns the start time of the current
- statement (more specifically, the time of receipt of the latest command
+ statement (more specifically, the time of receipt of the latest protocol
message from the client).
<function>statement_timestamp()</function> and <function>transaction_timestamp()</function>
- return the same value during the first command of a transaction, but might
- differ during subsequent commands.
+ return the same value during the first statement of a transaction, but might
+ differ during subsequent statements.
<function>clock_timestamp()</function> returns the actual current time, and
- therefore its value changes even within a single SQL command.
+ therefore its value changes even within a single SQL statement.
<function>timeofday()</function> is a historical
<productname>PostgreSQL</productname> function. Like
<function>clock_timestamp()</function>, it returns the actual current time,
view thread (21+ messages) latest in thread
Message-ID: <458204.1752443813@sss.pgh.pa.us>
Permalink: ../458204.1752443813@sss.pgh.pa.us/
Also on: postgresql.org/message-id/458204.1752443813@sss.pgh.pa.us
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: tgl@sss.pgh.pa.us, laurenz.albe@cybertec.at, petermittere@gmail.com, pgsql-docs@lists.postgresql.org
Subject: Re: please define 'statement' in the glossary
In-Reply-To: <458204.1752443813@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox