Обсуждение: returning clause is not clearly documented

Поиск
Список
Период
Сортировка

returning clause is not clearly documented

От
PG Doc comments form
Дата:
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

От
"David G. Johnston"
Дата:
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.