Re: Specify bytes storage for enum data types

From: Sumit Sengupta <ssengupta(at)hotmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-docs(at)lists(dot)postgresql(dot)org" <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: Specify bytes storage for enum data types
Date: 2022-05-05 13:04:18
Message-ID: BL0PR06MB4978F6C0B69F3F03AEBED0FBB3C29@BL0PR06MB4978.namprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

Thanks David. I overlooked that at the bottom. I guess it would still be nice to mention the storage at the top like other data types.
________________________________
From: David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
Sent: Thursday, May 5, 2022 8:30 AM
To: ssengupta(at)hotmail(dot)com <ssengupta(at)hotmail(dot)com>; pgsql-docs(at)lists(dot)postgresql(dot)org <pgsql-docs(at)lists(dot)postgresql(dot)org>
Subject: Re: Specify bytes storage for enum data types

On Wednesday, May 4, 2022, PG Doc comments form <noreply(at)postgresql(dot)org<mailto:noreply(at)postgresql(dot)org>> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/datatype-enum.html
Description:

I love Postgres !! And also its documentation !!

While reading through data types, it occurred to me that most ( if not every
) other data types has a chart on the top saying how many bytes it
occuies.
Like all numerical, date or char data types.

For enum it would be nice to have that info as well.
I am assuming it is variable ? May be 1 or 2 bytes for the definition and
the rest depending on the enum values ?

A clarification would be nice !

Second to last sentence on the page.

Storage only measures the size of a single value on a data row.

David J.

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2022-05-07 22:12:06 Docs about INSERT wait in Read Commited transaction
Previous Message David G. Johnston 2022-05-05 12:30:58 Re: Specify bytes storage for enum data types