Re: https://www.postgresql.org/docs/current/sql-insert.html

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "lacroix(dot)robert(at)outlook(dot)com" <lacroix(dot)robert(at)outlook(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: https://www.postgresql.org/docs/current/sql-insert.html
Date: 2024-11-05 13:26:31
Message-ID: CAKFQuwYX0nsfChiKnDe-nLZpt_N+EkiM776GE2JzrO=PxyHJyg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

On Saturday, November 2, 2024, PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/17/sql-insert.html
> Description:
>
> Is my suspicion valid?
>

The presence of the returning clause and subsequent usage of the CTE name
in the select/insert ensures that the update executes first.

David J.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2024-11-05 15:05:22 Serializable Transaction Anomoly
Previous Message Egor Rogov 2024-11-05 09:12:14 Parallel index build for BRIN