Are you guaranteed to get the same order back when using Prefer: return=representation? #2953
-
|
When you insert/upsert multiple rows in a table and use |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 1 reply
-
|
No, there is no such guarantee. See also a thread on pgsql-general from earlier this year: https://www.postgresql.org/message-id/flat/2b8d529a-0ec-4e8f-26d3-2ef2881a2d49%40evolvis.org#3fdbbeb01a034274951b238c30854704 Given that there is no "proper" way to do it in PostgreSQL itself, we don't do it here either. |
Beta Was this translation helpful? Give feedback.
-
|
That's unfortunate, but thanks for the quick answer! |
Beta Was this translation helpful? Give feedback.
No, there is no such guarantee. See also a thread on pgsql-general from earlier this year: https://www.postgresql.org/message-id/flat/2b8d529a-0ec-4e8f-26d3-2ef2881a2d49%40evolvis.org#3fdbbeb01a034274951b238c30854704
Given that there is no "proper" way to do it in PostgreSQL itself, we don't do it here either.