MIME-Version: 1.0
References: <CAOzAquKPXRWp38u9cURDCd4XzKCbKLhuZvH6AQjtXGW3R6-LoQ@mail.gmail.com>
 <577338.1720304029@sss.pgh.pa.us> <CAFj8pRBcwQ3CVGj7eDFezhG-dUtrsry3T9iHf0SmEnU=YXs-LQ@mail.gmail.com>
 <CAFj8pRBZUNjmDXwByeSuE5H+vQGBDyn-AQg9-kRX4eKrAUqOCQ@mail.gmail.com> <CAOzAquK=sA1_PRVB3unA9uyByvSjVH3QMhd2Pjkxk_845sSPFg@mail.gmail.com>
In-Reply-To: <CAOzAquK=sA1_PRVB3unA9uyByvSjVH3QMhd2Pjkxk_845sSPFg@mail.gmail.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Sun, 7 Jul 2024 16:42:07 +0200
Message-ID: <CAFj8pRCMpZ-pn8v_U316X=rKvPCg1nbe+_aKpj0qPUGy8fiqfw@mail.gmail.com>
Subject: Re: Declaring a field that is also an out parameter in a function
To: Michael Nolan <htfoot@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, 
	"pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002eb364061ca94fbe"
Archived-At: <https://www.postgresql.org/message-id/CAFj8pRCMpZ-pn8v_U316X%3DrKvPCg1nbe%2B_aKpj0qPUGy8fiqfw%40mail.gmail.com>
Precedence: bulk

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

ne 7. 7. 2024 v 15:01 odes=C3=ADlatel Michael Nolan <htfoot@gmail.com> naps=
al:

> On Sun, Jul 7, 2024 at 4:13=E2=80=AFAM Pavel Stehule <pavel.stehule@gmail=
.com>
> wrote:
> >
> > but looks so there are false alarms related to using an alias. It is
> interesting so I have not any report about this issue, so probably using
> aliases is not too common today.
>
> I'm not sure why there's a warning about using an alias. 43.3.1 says
> to use them for improved readability.
>

it is obsolete - aliases were used when Postgres doesn't support named
arguments.

I  don't know any good reason why one variable can use more than one name.

There can be an exception when argument names are very long, but generally
they are not used.


>
> Mike Nolan
>

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">ne 7. 7. 2024 v=C2=A015:01 odes=C3=AD=
latel Michael Nolan &lt;<a href=3D"mailto:htfoot@gmail.com">htfoot@gmail.co=
m</a>&gt; napsal:<br></div><blockquote class=3D"gmail_quote" style=3D"margi=
n:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex=
">On Sun, Jul 7, 2024 at 4:13=E2=80=AFAM Pavel Stehule &lt;<a href=3D"mailt=
o:pavel.stehule@gmail.com" target=3D"_blank">pavel.stehule@gmail.com</a>&gt=
; wrote:<br>
&gt;<br>
&gt; but looks so there are false alarms related to using an alias. It is i=
nteresting so I have not any report about this issue, so probably using ali=
ases is not too common today.<br>
<br>
I&#39;m not sure why there&#39;s a warning about using an alias. 43.3.1 say=
s<br>
to use them for improved readability.<br></blockquote><div><br></div><div>i=
t is obsolete - aliases were used when Postgres doesn&#39;t support named a=
rguments.</div><div><br></div><div>I=C2=A0 don&#39;t know any good reason w=
hy one variable can use more than one name.</div><div><br></div><div>There =
can be an exception when argument names are very long, but generally they a=
re not used.</div><div><br></div><div>=C2=A0<br></div><blockquote class=3D"=
gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(20=
4,204,204);padding-left:1ex">
<br>
Mike Nolan<br>
</blockquote></div></div>

--0000000000002eb364061ca94fbe--