Thread: Update wording of INSERT ON CONFLICT "rows proposed for insertion"

Update wording of INSERT ON CONFLICT "rows proposed for insertion"

From
"David G. Johnston"
Date:
Hey,

I suggest a minor rewording of:


Current:
"The SET and WHERE clauses in ON CONFLICT DO UPDATE have access to the existing row using the table's name (or an alias), and to [rows] proposed for insertion using the special excluded table."

Becomes:
"The SET and WHERE clauses in ON CONFLICT DO UPDATE have access to the existing row using the table's name (or an alias), and to [the corresponding row] proposed for insertion using the special excluded table."

The plural "rows" just reads oddly since in any single evaluation only one row is going to be present in the excluded table for the "existing row" in the target table.

David J.

Re: Update wording of INSERT ON CONFLICT "rows proposed for insertion"

From
"David G. Johnston"
Date:
On Tue, Mar 8, 2022 at 5:14 PM David G. Johnston <david.g.johnston@gmail.com> wrote:

Concretely as attached.  I did a bit more than minor work - I decided that actually calling it a table in the docs didn't really fit how it behaves in practice and so reworded the "table" into just "name".  Please see the commit message for more exposition.

David J.

Attachment