MIME-Version: 1.0
In-Reply-To: <164698257526.655.5597762736617707697@wrigleys.postgresql.org>
References: <164698257526.655.5597762736617707697@wrigleys.postgresql.org>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Fri, 11 Mar 2022 07:53:48 -0700
Message-ID: 
 <CAKFQuwa_TJeAWJnqZz4_xexabB2bgRi9sO5-D=XFo-_FZNCYCg@mail.gmail.com>
Subject: Re: returning clause is not clearly documented
To: "mf.esp1400@gmail.com" <mf.esp1400@gmail.com>,
	"pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000093d46305d9f27f92"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwa_TJeAWJnqZz4_xexabB2bgRi9sO5-D%3DXFo-_FZNCYCg%40mail.gmail.com>
Precedence: bulk

--00000000000093d46305d9f27f92
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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 th=
en
> to return to then front-end.
> How I must do in same cases?
>

It doesn=E2=80=99t matter how many rows are affected, returning will return=
 them
all.

David J.

--00000000000093d46305d9f27f92
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Friday, March 11, 2022, PG Doc comments form &lt;<a href=3D"mailto:norep=
ly@postgresql.org">noreply@postgresql.org</a>&gt; wrote:<br><blockquote cla=
ss=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pa=
dding-left:1ex">The following documentation comment has been logged on the =
website:<br>
<br>
Page: <a href=3D"https://www.postgresql.org/docs/14/dml-returning.html" tar=
get=3D"_blank">https://www.postgresql.org/<wbr>docs/14/dml-returning.html</=
a><br>
Description:<br>
<br>
Hello there<br>
I&#39;m not good enough in english, so have my excuse.<br>
<br>
I don&#39;t undestand how Returning clause work when more than on row are<b=
r>
affected. i.e I have an update with 3 rows affected and I want to have then=
<br>
to return to then front-end.<br>
How I must do in same cases?<br>
</blockquote><div><br></div><div>It doesn=E2=80=99t matter how many rows ar=
e affected, returning will return them all.</div><div><br></div><div>David =
J.</div><div><br></div>

--00000000000093d46305d9f27f92--