Re: Guidance on INSERT RETURNING order

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Guidance on INSERT RETURNING order
Дата
Msg-id 1678721.1681566044@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Guidance on INSERT RETURNING order  (Federico <cfederico87@gmail.com>)
Ответы Re: Guidance on INSERT RETURNING order  (Federico <cfederico87@gmail.com>)
Список pgsql-general
Federico <cfederico87@gmail.com> writes:
> I think the tuple order would not be connected to the values, but be
> determined by the input order of the rows in the insert. So when using
> INSERT ... SELECT the tuple_order value would be determined by the
> output of the select, using the same logic as ROW_NUMBER.

We already rejected the idea that INSERT must preserve the order of
the incoming tuples.  Please don't re-propose it with different
wording.

            regards, tom lane



В списке pgsql-general по дате отправления:

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: JSON / ASP.NET AJAX Dates support in PostgreSQL
Следующее
От: Federico
Дата:
Сообщение: Re: Guidance on INSERT RETURNING order