Confusing bit in the "EXAMPLES" section for INSERT

From: Erwin Brandstetter <brsaweda(at)gmail(dot)com>
To: pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: Confusing bit in the "EXAMPLES" section for INSERT
Date: 2022-08-16 21:09:59
Message-ID: CAGHENJ7yUGqJOARrq59sxyoUim51Gobz2edHV38AxVZgHxdCSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

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 the did column:
>

Suggesting this as replacement:

Insert a distributor, or do nothing if the proposed row conflicts with an
existing row. Per-row triggers BEFORE INSERT are fired, and possible
effects on the proposed applied, before checking for conflicts. Example
assumes a unique index on the did column exists:

Regards
Erwin

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Erwin Brandstetter 2022-08-16 21:14:26 Re: Confusing bit in the "EXAMPLES" section for INSERT
Previous Message Bruce Momjian 2022-08-16 19:38:13 Re: SQL-standard function bodies and creating SECURITY DEFINER routines securely