| From: | Eric Hanson <eric(at)aquameta(dot)com> |
|---|---|
| To: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
| Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: "name" vs "alias" in datatype table |
| Date: | 2023-11-29 15:16:57 |
| Message-ID: | CACA6kxixrAJoTt7MpUtbuT++JDifWiPQCLJ5YzFzpML2Pm-WYQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
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 AM Eric Hanson <eric(at)aquameta(dot)com> wrote:
> On Wed, Nov 29, 2023 at 7:40 AM Peter Eisentraut <peter(at)eisentraut(dot)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.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Euler Taveira | 2023-11-29 15:24:23 | Re: Clarification regarding CREATE TABLE LIKE and FOREIGN KEYS |
| Previous Message | Eric Hanson | 2023-11-29 14:10:29 | Re: "name" vs "alias" in datatype table |