Thread: returning clause is not clearly documented

returning clause is not clearly documented

From
PG Doc comments form
Date:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/dml-returning.html
Description:

Hello there
I'm not good enough in english, so have my excuse.

I don't undestand how Returning clause work when more than on row are
affected. i.e I have an update with 3 rows affected and I want to have then
to return to then front-end.
How I must do in same cases?

thank you

Re: returning clause is not clearly documented

From
"David G. Johnston"
Date:
On Friday, March 11, 2022, PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/dml-returning.html
Description:

Hello there
I'm not good enough in english, so have my excuse.

I don't undestand how Returning clause work when more than on row are
affected. i.e I have an update with 3 rows affected and I want to have then
to return to then front-end.
How I must do in same cases?

It doesn’t matter how many rows are affected, returning will return them all.

David J.