MIME-Version: 1.0
References: <170077271331.398198.16997446522206025709@wrigleys.postgresql.org>
 <83419ce9-e2ba-46e9-aaff-f6bbe448a327@eisentraut.org>
 <CACA6kxjoGV+QxpvBa20Vdu+of3gxATWuot8FLSa1Sm2BfikN4w@mail.gmail.com>
In-Reply-To: 
 <CACA6kxjoGV+QxpvBa20Vdu+of3gxATWuot8FLSa1Sm2BfikN4w@mail.gmail.com>
From: Eric Hanson <eric@aquameta.com>
Date: Wed, 29 Nov 2023 09:16:57 -0600
Message-ID: 
 <CACA6kxixrAJoTt7MpUtbuT++JDifWiPQCLJ5YzFzpML2Pm-WYQ@mail.gmail.com>
Subject: Re: "name" vs "alias" in datatype table
To: Peter Eisentraut <peter@eisentraut.org>
Cc: pgsql-docs@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000007c94a4060b4c0755"
Archived-At: 
 <https://www.postgresql.org/message-id/CACA6kxixrAJoTt7MpUtbuT%2B%2BJDifWiPQCLJ5YzFzpML2Pm-WYQ%40mail.gmail.com>
Precedence: bulk

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

The larger point being, the "name" vs "alias" paradigm presented in this
table does not accurately represent PostgreSQL, and conveys an inaccurate
picture of the relationship between type names.  int4 is not an "alias".

On Wed, Nov 29, 2023 at 8:10=E2=80=AFAM Eric Hanson <eric@aquameta.com> wro=
te:

> On Wed, Nov 29, 2023 at 7:40=E2=80=AFAM Peter Eisentraut <peter@eisentrau=
t.org>
> wrote:
>
>> On 23.11.23 21:51, PG Doc comments form wrote:
>> > I think there could be some clarification of what is a "name" vs.
>> "alias" on
>> > the datatypes table.  Right now, what's in the "Aliases" column is
>> sometimes
>> > postgres's internal type (e.g. `pg_catalog.int4`), and sometimes the
>> "pretty
>> > name", (e.g. `integer`).
>>
>> This appears not to be true.  `integer` is not listed as an alias.
>>
>
> Sorry, "int" is, and it is not in pg_type.
>

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

<div dir=3D"ltr">The larger point being, the &quot;name&quot; vs &quot;alia=
s&quot; paradigm presented in this table does not accurately represent Post=
greSQL, and conveys an inaccurate picture of the relationship between type =
names.=C2=A0 int4 is not an &quot;alias&quot;.</div><br><div class=3D"gmail=
_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, Nov 29, 2023 at 8:10=
=E2=80=AFAM Eric Hanson &lt;<a href=3D"mailto:eric@aquameta.com">eric@aquam=
eta.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Wed, Nov 29, 2023 at 7:40=E2=80=
=AFAM Peter Eisentraut &lt;<a href=3D"mailto:peter@eisentraut.org" target=
=3D"_blank">peter@eisentraut.org</a>&gt; wrote:<br></div><div class=3D"gmai=
l_quote"><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left:1px solid rgb(204,204,204);padding-left:1ex">On 23.11.23 21:5=
1, PG Doc comments form wrote:<br>
&gt; I think there could be some clarification of what is a &quot;name&quot=
; vs. &quot;alias&quot; on<br>
&gt; the datatypes table.=C2=A0 Right now, what&#39;s in the &quot;Aliases&=
quot; column is sometimes<br>
&gt; postgres&#39;s internal type (e.g. `pg_catalog.int4`), and sometimes t=
he &quot;pretty<br>
&gt; name&quot;, (e.g. `integer`).<br>
<br>
This appears not to be true.=C2=A0 `integer` is not listed as an alias.<br>=
</blockquote><div><br></div><div>Sorry, &quot;int&quot; is, and it is not i=
n pg_type.=C2=A0</div></div></div>
</blockquote></div>

--0000000000007c94a4060b4c0755--