Re: Small docs bugfix: make it clear what can be used in UPDATE FROMand DELETE USING - Mailing list pgsql-hackers

From David Fetter
Subject Re: Small docs bugfix: make it clear what can be used in UPDATE FROMand DELETE USING
Date
Msg-id 20200213151123.GT24870@fetter.org
Whole thread Raw
In response to Small docs bugfix: make it clear what can be used in UPDATE FROM andDELETE USING  (Alexey Bashtanov <bashtanov@imap.cc>)
List pgsql-hackers
On Thu, Feb 13, 2020 at 11:13:32AM +0000, Alexey Bashtanov wrote:
> 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.

Thanks for doing this!

Speaking of examples, there should be more of them illustrating some
of the cases you name.

Best,
David.
-- 
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate



pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Small docs bugfix: make it clear what can be used in UPDATE FROMand DELETE USING
Next
From: Pavel Stehule
Date:
Subject: Re: Optimize update of tables with generated columns