Re: Postgres do not support tinyint? - Mailing list pgsql-general

From Dominique Devienne
Subject Re: Postgres do not support tinyint?
Date
Msg-id CAFCRh-87K0kLsXFSYeTj1xZvG-maq0qv4eRVt5iMs2j-6LNBMQ@mail.gmail.com
Whole thread Raw
In response to Re: Postgres do not support tinyint?  (Vladlen Popolitov <v.popolitov@postgrespro.ru>)
Responses Re: Postgres do not support tinyint?
Re: Postgres do not support tinyint?
List pgsql-general
On Fri, Jan 10, 2025 at 10:13 AM Vladlen Popolitov
<v.popolitov@postgrespro.ru> wrote:
> If you really need 1-byte integer, you can use "char" type. Cast it
> to/from int. See comment at the end of the page
> https://www.postgresql.org/docs/17/datatype-character.html

Hi. What would be the best online doc to learn about the physical
storage / format for rows/pages/btree, etc... To understand alignment,
packing, varint or not, all those things. I'm quite familiar with the
[SQLite format][1], having read that doc dozens of times, and I'd like
a better low-level understanding for PostgreSQL as well. TIA, --DD

[1]: https://www.sqlite.org/fileformat.html



pgsql-general by date:

Previous
From: Vladlen Popolitov
Date:
Subject: Re: Postgres do not support tinyint?
Next
From: shammat@gmx.net
Date:
Subject: Re: Postgres do not support tinyint?