Confusing bit in the "EXAMPLES" section for INSERT - Mailing list pgsql-docs

From Erwin Brandstetter
Subject Confusing bit in the "EXAMPLES" section for INSERT
Date
Msg-id CAGHENJ7yUGqJOARrq59sxyoUim51Gobz2edHV38AxVZgHxdCSQ@mail.gmail.com
Whole thread Raw
Responses Re: Confusing bit in the "EXAMPLES" section for INSERT
Re: Confusing bit in the "EXAMPLES" section for INSERT
List pgsql-docs

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

pgsql-docs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: SQL-standard function bodies and creating SECURITY DEFINER routines securely
Next
From: Erwin Brandstetter
Date:
Subject: Re: Confusing bit in the "EXAMPLES" section for INSERT