| From: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
|---|---|
| To: | Vladlen Popolitov <v(dot)popolitov(at)postgrespro(dot)ru> |
| Cc: | Igor Korot <ikorot01(at)gmail(dot)com>, Christophe Pettus <xof(at)thebuild(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Ron Johnson <ronljohnsonjr(at)gmail(dot)com>, "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Postgres do not support tinyint? |
| Date: | 2025-01-10 09:41:12 |
| Message-ID: | CAFCRh-87K0kLsXFSYeTj1xZvG-maq0qv4eRVt5iMs2j-6LNBMQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Jan 10, 2025 at 10:13 AM Vladlen Popolitov
<v(dot)popolitov(at)postgrespro(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shammat | 2025-01-10 10:44:29 | Re: Postgres do not support tinyint? |
| Previous Message | Vladlen Popolitov | 2025-01-10 09:13:05 | Re: Postgres do not support tinyint? |