Re: Guidance on INSERT RETURNING order - Mailing list pgsql-general

From Tom Lane
Subject Re: Guidance on INSERT RETURNING order
Date
Msg-id 1678721.1681566044@sss.pgh.pa.us
Whole thread Raw
In response to Re: Guidance on INSERT RETURNING order  (Federico <cfederico87@gmail.com>)
Responses Re: Guidance on INSERT RETURNING order
List pgsql-general
Federico <cfederico87@gmail.com> writes:
> I think the tuple order would not be connected to the values, but be
> determined by the input order of the rows in the insert. So when using
> INSERT ... SELECT the tuple_order value would be determined by the
> output of the select, using the same logic as ROW_NUMBER.

We already rejected the idea that INSERT must preserve the order of
the incoming tuples.  Please don't re-propose it with different
wording.

            regards, tom lane



pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: JSON / ASP.NET AJAX Dates support in PostgreSQL
Next
From: Federico
Date:
Subject: Re: Guidance on INSERT RETURNING order