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


Reply via email to