MIME-Version: 1.0
References: <CACX+KaPBaSW+0PyMC7dmY6W9W8mPSbWpkJRhAOQOC9Qb0TjCQA@mail.gmail.com>
 <CANzqJaA-Bmsq5npa1qCaQkDMb-4+9ZqZVUHqpVzURJ-RtSgS-w@mail.gmail.com> <CAKFQuwarhk+tg0iJVekT8FENSjhTBXhvVmbep6kWVrUzd1naaA@mail.gmail.com>
In-Reply-To: <CAKFQuwarhk+tg0iJVekT8FENSjhTBXhvVmbep6kWVrUzd1naaA@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 18 Jun 2024 13:54:37 -0400
Message-ID: <CANzqJaCWEJb8VXK=063GnE9VF71EAijXf_MCjHj48ooAyUw9bw@mail.gmail.com>
Subject: Re: Seeking Clarification on Function Definitions in PostgreSQL Extensions
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000028d6f7061b2dc7ef"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCWEJb8VXK%3D063GnE9VF71EAijXf_MCjHj48ooAyUw9bw%40mail.gmail.com>
Precedence: bulk

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

On Tue, Jun 18, 2024 at 1:16=E2=80=AFPM David G. Johnston <
david.g.johnston@gmail.com> wrote:

> On Tue, Jun 18, 2024 at 10:07=E2=80=AFAM Ron Johnson <ronljohnsonjr@gmail=
.com>
> wrote:
>
>> fun2 puzzles me.  Why would you return parameters AND *a single record* =
(unless
>> it's an error status).
>>
>
> You mis-understand what 2 is doing.  You should go re-read the docs for
> create function again.  Especially the description of rettype.
>

That's true.  I've even used "RETURNS SETOF record" before.

But I stand by returning OUT params and records at the same time.

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

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Jun 18, 2024 at 1:16=E2=80=AFPM D=
avid G. Johnston &lt;<a href=3D"mailto:david.g.johnston@gmail.com">david.g.=
johnston@gmail.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><bloc=
kquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:=
1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"l=
tr"><div style=3D"font-family:arial,helvetica,sans-serif"><span style=3D"fo=
nt-family:Arial,Helvetica,sans-serif">On Tue, Jun 18, 2024 at 10:07=E2=80=
=AFAM Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com" target=3D"=
_blank">ronljohnsonjr@gmail.com</a>&gt; wrote:</span><br></div></div><div c=
lass=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px =
0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div=
 dir=3D"ltr"><div>fun2 puzzles=C2=A0me.=C2=A0 Why would you return paramete=
rs AND <i>a single record</i>=C2=A0(unless it&#39;s an error status).<br></=
div></div></blockquote><div><br></div><div style=3D"font-family:arial,helve=
tica,sans-serif">You mis-understand what 2 is doing.=C2=A0 You should go re=
-read the docs for create function again.=C2=A0 Especially the description =
of rettype.</div></div></div></blockquote><div><br></div><div>That&#39;s tr=
ue.=C2=A0 I&#39;ve even used &quot;RETURNS SETOF record&quot; before.</div>=
<div><br></div><div>But I stand by returning OUT params and records at the =
same=C2=A0time.</div></div></div>

--00000000000028d6f7061b2dc7ef--