Re: Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows - Mailing list pgsql-hackers

From Vik Reykja
Subject Re: Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows
Date
Msg-id CALDgxVtv9KtrfwRV5pnSxGa-9R6MpUJAoTKHGjHFys3hCqSZYg@mail.gmail.com
Whole thread
In response to Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows  (Abhijit Menon-Sen <ams@2ndQuadrant.com>)
Responses Re: Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows
List pgsql-hackers
On Sun, Oct 21, 2012 at 6:20 PM, Abhijit Menon-Sen <ams@2ndquadrant.com> wrote:
At 2012-10-21 11:49:26 -0400, cbbrowne@gmail.com wrote:
>
> If there is a natural sequence (e.g. - a value assigned by nextval()),
> that offers a natural place to apply the usual order-imposing ORDER BY
> that we are expected to use elsewhere.

Note: "INSERT … RETURNING" doesn't accept an ORDER BY clause.

Would anyone be opposed to somebody - say, me - writing a patch to allow that?  It would take me a lot longer than an experienced hacker to do it, but I'm willing to try.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows
Next
From: Phil Sorber
Date:
Subject: Re: [WIP] pg_ping utility