Re: Specify bytes storage for enum data types

2022-05-05 Thread Sumit Sengupta
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 
Sent: Thursday, May 5, 2022 8:30 AM
To: ssengu...@hotmail.com ; 
pgsql-docs@lists.postgresql.org 
Subject: Re: Specify bytes storage for enum data types



On Wednesday, May 4, 2022, PG Doc comments form 
mailto:nore...@postgresql.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.


Re: Specify bytes storage for enum data types

2022-05-05 Thread David G. Johnston
On Wednesday, May 4, 2022, PG Doc comments form 
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.


Specify bytes storage for enum data types

2022-05-05 Thread PG Doc comments form
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 !

Thanks
- Sumit Sengupta