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>
 <CANzqJaCWEJb8VXK=063GnE9VF71EAijXf_MCjHj48ooAyUw9bw@mail.gmail.com> <CAKFQuwbBAks7=R0GDmSY91YGLp3_kt7nQ3_K_4u38GLz34NbLA@mail.gmail.com>
In-Reply-To: <CAKFQuwbBAks7=R0GDmSY91YGLp3_kt7nQ3_K_4u38GLz34NbLA@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 18 Jun 2024 14:27:10 -0400
Message-ID: <CANzqJaBy1Vwpo_fso+KKo_ubKaaA2etNkz-T5caCexQKQ5m9mg@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="00000000000095317f061b2e3bbb"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaBy1Vwpo_fso%2BKKo_ubKaaA2etNkz-T5caCexQKQ5m9mg%40mail.gmail.com>
Precedence: bulk

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

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

> On Tuesday, June 18, 2024, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
>
>>
>> But I stand by returning OUT params and records at the same time.
>>
>
> You mean you dislike adding the optional returns clause when output
> parameters exist?
>

Correct.  It breaks the distinction between function and procedure.


> Because the out parameters and the =E2=80=9Crecord=E2=80=9D represent the=
 exact same thing.
>

What's the purpose?  Legacy of not having procedures?

--00000000000095317f061b2e3bbb
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:57=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">On Tuesday, June 18, 2024, Ron=
 Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.com" target=3D"_blank">r=
onljohnsonjr@gmail.com</a>&gt; wrote:<br><blockquote class=3D"gmail_quote" =
style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pa=
dding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><br></div><div class=3D"g=
mail_quote"><div>But I stand by returning OUT params and records at the sam=
e=C2=A0time.</div></div></div></blockquote><div><br></div><div>You mean you=
 dislike adding the optional returns clause when output parameters exist?=
=C2=A0 </div></blockquote><div><br></div><div>Correct.=C2=A0 It breaks the =
distinction between function and procedure.</div><div>=C2=A0</div><blockquo=
te class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px =
solid rgb(204,204,204);padding-left:1ex"><div>Because the out parameters an=
d the =E2=80=9Crecord=E2=80=9D represent the exact same thing.</div></block=
quote><div>=C2=A0</div><div>What&#39;s the purpose?=C2=A0 Legacy of not hav=
ing procedures?=C2=A0</div><div><br></div><div><br></div><div><br></div></d=
iv></div>

--00000000000095317f061b2e3bbb--