public inbox for [email protected]  

help / color / mirror / Atom feed

From: Sumit Sengupta <[email protected]>
To: David G. Johnston <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Specify bytes storage for enum data types
Date: Thu, 5 May 2022 13:04:18 +0000
Message-ID: <BL0PR06MB4978F6C0B69F3F03AEBED0FBB3C29@BL0PR06MB4978.namprd06.prod.outlook.com> (raw)
In-Reply-To: <CAKFQuwauVwwr7_3zYtM3ACEJfQN+LimohSFGKX5opAs3CH2Liw@mail.gmail.com>
References: <[email protected]>
	<CAKFQuwauVwwr7_3zYtM3ACEJfQN+LimohSFGKX5opAs3CH2Liw@mail.gmail.com>

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 <[email protected]>
Sent: Thursday, May 5, 2022 8:30 AM
To: [email protected] <[email protected]>; [email protected] <[email protected]>
Subject: Re: Specify bytes storage for enum data types



On Wednesday, May 4, 2022, PG Doc comments form <[email protected]<mailto:[email protected]>> 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.

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Specify bytes storage for enum data types
  In-Reply-To: <BL0PR06MB4978F6C0B69F3F03AEBED0FBB3C29@BL0PR06MB4978.namprd06.prod.outlook.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox