public inbox for [email protected]
help / color / mirror / Atom feedFrom: Troy Frericks <[email protected]>
To: Bruce Momjian <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: Data Type Size Calculation
Date: Tue, 15 Feb 2022 12:50:05 -0600
Message-ID: <CAPpwsZzAS6XRLjcH0G9w9NgHekvDXxRH_A2pCiQGOgUJmokW7w@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
For now, yes... I'm suggesting that the documentation be completed by
adding a few sentences few extra sentences.
Troy.
#
On Mon, Feb 14, 2022, 12:51 Bruce Momjian <[email protected]> wrote:
> On Fri, Feb 11, 2022 at 08:12:08PM +0000, PG Doc comments form wrote:
> > The following documentation comment has been logged on the website:
> >
> > Page: https://www.postgresql.org/docs/13/datatype-numeric.html
> > Description:
> >
> > > The actual storage requirement is two bytes for each group of four
> decimal
> > digits, plus three to eight bytes overhead.
> >
> > Please describe what 'overhead' means.
> >
> > I'd like to be able to calculate the data size of NUMBER(19,4). I can
> > calculate 2 bytes per 4 digits... with 19 digits, I have 5 groups of 4
> > digits,
> >
> > so the data length I seek is 5 bytes + overhead... then I'm left hanging.
> > :(
>
> Well, you can create it and then call pg_column_size():
>
> CREATE TABLE test (x NUMERIC(19,4));
>
> SELECT pg_column_size('test.x');
> pg_column_size
> ----------------
> 7
>
> If you want more details, you will need to look at the source code.
>
> --
> Bruce Momjian <[email protected]> https://momjian.us
> EDB https://enterprisedb.com
>
> If only the physical world exists, free will is an illusion.
>
>
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], [email protected]
Subject: Re: Data Type Size Calculation
In-Reply-To: <CAPpwsZzAS6XRLjcH0G9w9NgHekvDXxRH_A2pCiQGOgUJmokW7w@mail.gmail.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