Re: Semantics around INSERT INTO with SELECT and ORDER BY.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Semantics around INSERT INTO with SELECT and ORDER BY.
Дата
Msg-id CAKFQuwZWFXPCN_kxhVqCL26OVkEGsrzCeM_NukxgfEZik55g7A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Semantics around INSERT INTO with SELECT and ORDER BY.  (Steve Krenzel <sgk284@gmail.com>)
Ответы Re: Semantics around INSERT INTO with SELECT and ORDER BY.
Список pgsql-general
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: "Daniel Verite"
Дата:
Сообщение: Re: pg_upgrade and wraparound
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Semantics around INSERT INTO with SELECT and ORDER BY.