Re: Specify bytes storage for enum data types

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
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
Date: 2022-05-05 12:30:58
Message-ID: CAKFQuwauVwwr7_3zYtM3ACEJfQN+LimohSFGKX5opAs3CH2Liw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Sumit Sengupta 2022-05-05 13:04:18 Re: Specify bytes storage for enum data types
Previous Message PG Doc comments form 2022-05-04 21:20:19 Specify bytes storage for enum data types