Обсуждение: Update wording of INSERT ON CONFLICT "rows proposed for insertion"

Поиск
Список
Период
Сортировка

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

От
"David G. Johnston"
Дата:
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.

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

От
"David G. Johnston"
Дата:
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.

Вложения