Postgres Pro
Downloads
Home   >   mailing lists

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

From Christopher Browne
Subject Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows
Date
Msg-id CAFNqd5XkSCoeX-146AFAqdYZ=0P-bo1YrRbFtrC=00ywn_JEnQ@mail.gmail.com
Whole thread Raw
In response to Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows  (Abhijit Menon-Sen <ams@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
<p dir="ltr">I agree that it seems inappropriate to preserve order.  That seems an inappropriate imposition,
inconsistentwith what SQL does elsewhere.<p dir="ltr"> 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.<pdir="ltr"> I suppose it is troublesome if there is no such natural sequence, but I wouldn't think it too
meaningfulto expect order without some visible source of order.

pgsql-hackers by date:

Previous
From: "David Johnston"
Date:
Subject: Re: Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows
Next
From: Abhijit Menon-Sen
Date:
Subject: Re: [PATCH] Enforce that INSERT...RETURNING preserves the order of multi rows