Postgres Pro
Downloads
Home   >   mailing lists

Re: Semantics around INSERT INTO with SELECT and ORDER BY. - Mailing list pgsql-general

From David G. Johnston
Subject Re: Semantics around INSERT INTO with SELECT and ORDER BY.
Date
Msg-id CAKFQuwZWFXPCN_kxhVqCL26OVkEGsrzCeM_NukxgfEZik55g7A@mail.gmail.com
Whole thread Raw
In response to Re: Semantics around INSERT INTO with SELECT and ORDER BY.  (Steve Krenzel <sgk284@gmail.com>)
Responses Re: Semantics around INSERT INTO with SELECT and ORDER BY.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
On Tuesday, June 12, 2018, Steve Krenzel <sgk284@gmail.com> wrote:
This is relevant for tables that have a column with a SERIAL type, I need to guarantee that the relative ordering remains the same as the ordering of the selected result set.

The logical insertion order, and thus the sequence values, will be assigned according to the order by.

David J. 

pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: pg_upgrade and wraparound
Next
From: Adrian Klaver
Date:
Subject: Re: Semantics around INSERT INTO with SELECT and ORDER BY.