MIME-Version: 1.0
In-Reply-To: <165169921944.683.8982699018922635049@wrigleys.postgresql.org>
References: <165169921944.683.8982699018922635049@wrigleys.postgresql.org>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Thu, 5 May 2022 05:30:58 -0700
Message-ID: 
 <CAKFQuwauVwwr7_3zYtM3ACEJfQN+LimohSFGKX5opAs3CH2Liw@mail.gmail.com>
Subject: Re: Specify bytes storage for enum data types
To: "ssengupta@hotmail.com" <ssengupta@hotmail.com>,
	"pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000007d51e05de42ea2f"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwauVwwr7_3zYtM3ACEJfQN%2BLimohSFGKX5opAs3CH2Liw%40mail.gmail.com>
Precedence: bulk

--00000000000007d51e05de42ea2f
Content-Type: text/plain; charset="UTF-8"

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

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

<br><br>On Wednesday, May 4, 2022, PG Doc comments form &lt;<a href=3D"mail=
to:noreply@postgresql.org">noreply@postgresql.org</a>&gt; wrote:<br><blockq=
uote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc =
solid;padding-left:1ex">The following documentation comment has been logged=
 on the website:<br>
<br>
Page: <a href=3D"https://www.postgresql.org/docs/14/datatype-enum.html" tar=
get=3D"_blank">https://www.postgresql.org/<wbr>docs/14/datatype-enum.html</=
a><br>
Description:<br>
<br>
I love Postgres !! And also its documentation !!<br>
<br>
While reading through data types, it occurred to me that most ( if not ever=
y<br>
) other data types has a chart on the top saying how many bytes it<br>
occuies.<br>
Like all numerical, date or char data types.<br>
<br>
For enum it would be nice to have that info as well.<br>
I am assuming it is variable ? May be 1 or 2 bytes for the definition and<b=
r>
the rest depending on the enum values ? <br>
<br>
A clarification would be nice !<br>
</blockquote><div><br></div><div>Second to last sentence on the page.</div>=
<div><br></div><div>Storage only measures the size of a single value on a d=
ata row.</div><div><br></div><div>David J.=C2=A0</div>

--00000000000007d51e05de42ea2f--