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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Pg Docs <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Update wording of INSERT ON CONFLICT "rows proposed for insertion"
Date: 2022-03-09 00:14:11
Message-ID: CAKFQuwZKQoOEHQgTREb7swqryWjHVckcrpOrHUKQqEHznsZfGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Hey,

I suggest a minor rewording of:

https://www.postgresql.org/docs/devel/sql-insert.html

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.

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Michael Paquier 2022-03-09 01:45:18 Re: add free space map link in pg_freespacemap page
Previous Message Tom Lane 2022-03-08 16:39:09 Re: Missing information about CREATE TRIGGER on temporary tables