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.
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 |