Re: Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows

From: Vik Reykja <vikreykja(at)gmail(dot)com>
To: Abhijit Menon-Sen <ams(at)2ndquadrant(dot)com>
Cc: Christopher Browne <cbbrowne(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows
Date: 2012-10-21 20:29:39
Message-ID: CALDgxVtv9KtrfwRV5pnSxGa-9R6MpUJAoTKHGjHFys3hCqSZYg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Oct 21, 2012 at 6:20 PM, Abhijit Menon-Sen <ams(at)2ndquadrant(dot)com>wrote:

> At 2012-10-21 11:49:26 -0400, cbbrowne(at)gmail(dot)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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Phil Sorber 2012-10-21 20:51:21 Re: [WIP] pg_ping utility
Previous Message Tom Lane 2012-10-21 19:08:05 Re: Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows