Re: INSERT RETURNING

On Sun, Aug 28, 2022 at 7:51 AM PG Doc comments form <noreply(at)postgresql(dot)org>
wrote:

> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/14/dml-returning.html
> Description:
>
> If I execute the below query
> ```
> CREATE TABLE users (
> id serial primary key,
> name varchar(255)
> )
> INSERT INTO users (name) VALUES ('a'), ('b'), ('c') RETURNING id
> ```
> Is there any chance that the order of the returned ids is different from
> the
> order of data passed
> To be more clear, if the returned ids are `1, 2, 3`, is it guaranteed that
> the data order is ((1, a), (2, b), (3, c)) or can it be ((1, b), (2, a),
> (3,
> c))?
>

There is no guarantee that insertion will happen in any particular order.
If you have to associate a given generated id with a given record either
the record must have it own natural key (in which case return both the
natural and surrogate keys) or you have to insert one record at a time.

David J.