MIME-Version: 1.0
References: <CA+FnnTzfvgVdptHcLBFPrq_Q+xPes-Bhjiw_xFiooq4VqhqyrQ@mail.gmail.com>
 <CANzqJaCxZK0j8fL-riZpX+AV+kyo9PcAvgF=H5DgaWK+C+66Vw@mail.gmail.com>
In-Reply-To: <CANzqJaCxZK0j8fL-riZpX+AV+kyo9PcAvgF=H5DgaWK+C+66Vw@mail.gmail.com>
From: Igor Korot <ikorot01@gmail.com>
Date: Wed, 8 Jan 2025 00:26:32 -0600
Message-ID: <CA+FnnTz6GK0rKuC+g+LH25-N75ej-WGq7WZ1kpQZ9gtSbDeA+g@mail.gmail.com>
Subject: Re: Postgres do not support tinyint?
To: Ron Johnson <ronljohnsonjr@gmail.com>, 
	"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CA%2BFnnTz6GK0rKuC%2Bg%2BLH25-N75ej-WGq7WZ1kpQZ9gtSbDeA%2Bg%40mail.gmail.com>
Precedence: bulk

Hi, Ron,

On Tue, Jan 7, 2025 at 11:24=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.co=
m> wrote:
>
> On Wed, Jan 8, 2025 at 12:06=E2=80=AFAM Igor Korot <ikorot01@gmail.com> w=
rote:
>>
>> Hi, ALL,
>> According to https://www.postgresql.org/docs/9.1/datatype-numeric.html, =
the
>> smallest numeric type supports numbers from -32768 to 32767/
>>
>> My data will be in a range of [0..4], and so I guess my DB table will wa=
ste
>> space, right?
>
>
> 1. It's not 1994 anymore, when 8M rows was enormous.
> 2. Record structures are padded by word size, so tinyint wouldn't matter =
unless you specifically ordered the fixed width columns from largest to sma=
llest size when creating the table.
> 3. The "bit" type might serve your needs.

 I don't see the "bit" field here:
https://www.postgresql.org/docs/current/datatype-numeric.html...

Thank you..

>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> lobster!