On Thu, Dec 10, 2020 at 7:49 PM David G. Johnston <david.g.johns...@gmail.com> wrote: > > On Thursday, December 10, 2020, Ashutosh Bapat <ashutosh.bapat....@gmail.com> > wrote: >> >> On Wed, Dec 9, 2020 at 9:10 PM David G. Johnston >> <david.g.johns...@gmail.com> wrote: >> > >> > Hey, >> > >> > Would it be accurate to add the following sentence to the INSERT >> > documentation under "Outputs"? >> > >> > "...inserted or updated by the command." For a multiple-values insertion, >> > the order of output rows will match the order that rows are presented in >> > the values or query clause. >> >> Postgres's current implementation may be doing so, but I don't think >> that can be guaranteed in possible implementations. I don't think >> restricting choice of implementation to guarantee that is a good idea >> either. >> > > Yeah, the ongoing work on parallel inserts would seem to be an issue. We > should probably document that though. And maybe as part of parallel inserts > patch provide a user-specifiable way to ask for such a guarantee if needed. > ‘Insert returning ordered”
I am curious about the usecase which needs that guarantee? Don't you have a column on which you can ORDER BY so that it returns the same order as INSERT? -- Best Wishes, Ashutosh Bapat