Small docs bugfix: make it clear what can be used in UPDATE FROM and DELETE USING

From: Alexey Bashtanov <bashtanov(at)imap(dot)cc>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Small docs bugfix: make it clear what can be used in UPDATE FROM and DELETE USING
Date: 2020-02-13 11:13:32
Message-ID: 968d4724-8e58-788f-7c45-f7b1813824cc@imap.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

Currently the documentation says that one can put "a list of table
expressions"
after FROM in UPDATE or after USING in DELETE.
However, "table expression" is defined as a complex of
FROM, WHERE, GROUP BY and HAVING clauses [1].
The thing one can list in the FROM clause in a comma-separated manner
is called a table reference [2].
SELECT reference does not use this term but explains what they could be [3].

Please could someone have a look at the patch attached?
It's not just pedantry but rather based on a real-life example of
someone reading and being not sure
whether e.g. joins can be used in there.

Best, Alex

[1] https://www.postgresql.org/docs/devel/queries-table-expressions.html
[2]
https://www.postgresql.org/docs/devel/queries-table-expressions.html#QUERIES-FROM
[3] https://www.postgresql.org/docs/devel/sql-select.html#SQL-FROM

Attachment Content-Type Size
doc_update_from_v1.diff text/x-patch 2.0 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Antonin Houska 2020-02-13 11:15:39 Dead code in adminpack
Previous Message Peter Eisentraut 2020-02-13 11:00:54 allow running parts of src/tools/msvc/ under not Windows