Re: Confusing bit in the "EXAMPLES" section for INSERT
| От | Erwin Brandstetter |
|---|---|
| Тема | Re: Confusing bit in the "EXAMPLES" section for INSERT |
| Дата | |
| Msg-id | CAGHENJ7Lx-w4zMLgfrpo6nEk7P44i7yG_-q+QiDKSTPJvs-z=g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Confusing bit in the "EXAMPLES" section for INSERT (Erwin Brandstetter <brsaweda@gmail.com>) |
| Список | pgsql-docs |
Seeing that an earlier, related passage in the text reads:
> Note that the effects of all per-row
BEFORE INSERT triggers are reflected in excluded values, ...I update my suggestion to use the same expression:
Insert a distributor, or do nothing if the proposed row conflicts with an existing row. Per-row
BEFORE INSERT triggers are fired, and possible effects on the proposed row applied, before checking for conflicts. Example assumes a unique index on the did column exists:Regards
Erwin
On Tue, 16 Aug 2022 at 23:09, Erwin Brandstetter <brsaweda@gmail.com> wrote:
Insert a distributor, or do nothing for rows proposed for insertion when an existing, excluded row (a row with a matching constrained column or columns after before row insert triggers fire) exists. Example assumes a unique index has been defined that constrains values appearing in thedidcolumn:Suggesting this as replacement:Insert a distributor, or do nothing if the proposed row conflicts with an existing row. Per-row triggersBEFORE INSERTare fired, and possible effects on the proposed applied, before checking for conflicts. Example assumes a unique index on thedidcolumn exists:RegardsErwin
В списке pgsql-docs по дате отправления: