Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT

Поиск
Список
Период
Сортировка
Искать
От
Bruce Momjian
Тема
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT
Дата
Msg-id
YtBv3ixsUyKhFY3y@momjian.us
Ответ на
Список
Дерево обсуждения
doc: Clarify what "excluded" represents for INSERT ON CONFLICT "David G. Johnston" <david.g.johnston@gmail.com>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT Robert Haas <robertmhaas@gmail.com>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT Peter Geoghegan <pg@bowt.ie>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT Robert Haas <robertmhaas@gmail.com>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT "David G. Johnston" <david.g.johnston@gmail.com>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT Peter Geoghegan <pg@bowt.ie>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT "David G. Johnston" <david.g.johnston@gmail.com>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT Peter Geoghegan <pg@bowt.ie>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT Robert Haas <robertmhaas@gmail.com>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT Tom Lane <tgl@sss.pgh.pa.us>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT Peter Geoghegan <pg@bowt.ie>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT Peter Geoghegan <pg@bowt.ie>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT "David G. Johnston" <david.g.johnston@gmail.com>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT Bruce Momjian <bruce@momjian.us>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT Robert Haas <robertmhaas@gmail.com>
Re: doc: Clarify what "excluded" represents for INSERT ON CONFLICT Bruce Momjian <bruce@momjian.us>
On Fri, Jul  8, 2022 at 11:18:43PM -0400, Bruce Momjian wrote:
> On Fri, Jul  1, 2022 at 08:11:36AM -0700, David G. Johnston wrote:
> > That said, I still think that the current wording should be tweak with respect
> > to row vs. rows (especially if we continue to call it a table):
> > 
> > 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."
> > 
> > Change [rows] to:
> > 
> > "the row"
> > 
> > 
> > I'm undecided whether "FROM excluded" should be something that works - but I
> > also don't think it would actually be used in any case.
> 
> I found two places where a singular "row" would be better, doc patch
> attached.

Patch applied to all supported versions.

-- 
  Bruce Momjian          https://momjian.us
  EDB                                      https://enterprisedb.com

  Indecision is a decision.  Inaction is an action.  Mark Batterson



В списке pgsql-hackers по дате отправления
От: Bruce Momjian
Дата:
FAQ