agora inbox for pgsql-docs@postgresql.org  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: David G. Johnston <david.g.johnston@gmail.com>
Cc: 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: Mon, 14 Jul 2025 12:05:06 -0400
Message-ID: <690427.1752509106@sss.pgh.pa.us> (raw)
In-Reply-To: <CAKFQuwYzod+L_vjOuWz8OAte2SoS5V5ByOGfhDx1-ubvHTb11g@mail.gmail.com>
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>
	<458204.1752443813@sss.pgh.pa.us>
	<CAKFQuwa4VMoHehuN5qCX5Jv15ZahTJ00jxMu4mbtYNHbJ4PXOA@mail.gmail.com>
	<ec1e6bb700f9eefceea0648656b38ab223c14c54.camel@cybertec.at>
	<685003.1752506254@sss.pgh.pa.us>
	<CAKFQuwYzod+L_vjOuWz8OAte2SoS5V5ByOGfhDx1-ubvHTb11g@mail.gmail.com>

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> I dislike the word message.

> It would be nice if we could say/document: Command means top-level SQL;
> Statement references a sub-component of a command.

I think there are enough places where we use those words
interchangeably that it would be very difficult to get to a point of
consistently making the distinction.  Moreover, the distinction isn't
important for most purposes.  So I think the right route is to make
this para provide a self-contained description of what it's talking
about, rather than to reference a glossary entry that would likely
be misleading for many many other usages.

Perhaps the phrase "top-level statement" could be used, but I'd still
rather provide a parenthetical specification of what we mean by that.

I agree with Laurenz that we don't have to get into details as fine as
what happens with a multi-statement command message.  As long as we
can tie statement_timestamp() to the notion of receiving something
from the client, I think that's enough detail for here.  Somebody
who wants to probe the edges of that can read the code or experiment,
and the docs will have given them the right mind-set about what is
important.

			regards, tom lane





view thread (21+ messages)  latest in thread

Message-ID: <690427.1752509106@sss.pgh.pa.us>
Permalink:  ../690427.1752509106@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/690427.1752509106@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, david.g.johnston@gmail.com, laurenz.albe@cybertec.at, petermittere@gmail.com, pgsql-docs@lists.postgresql.org
  Subject: Re: please define 'statement' in the glossary
  In-Reply-To: <690427.1752509106@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