| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Igor Korot <ikorot01(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-08 05:20:56 |
| Message-ID: | 13a10c87-7ee8-4360-a401-6871fb8104cf@aklaver.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 1/7/25 21:06, Igor Korot wrote:
> Hi, ALL,
> According to https://www.postgresql.org/docs/9.1/datatype-numeric.html, the
> smallest numeric type supports numbers from -32768 to 32767/
In this case it does not matter, but you should not consult
documentation that is for a version(9.1) that is ~8 years past EOL.
Go here:
https://www.postgresql.org/docs/
and click on Current or the version you are actually using.
>
> My data will be in a range of [0..4], and so I guess my DB table will waste
> space, right?
Yes, though is that actually going to be an issue?
>
> Thank you.
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Johnson | 2025-01-08 05:24:21 | Re: Postgres do not support tinyint? |
| Previous Message | Igor Korot | 2025-01-08 05:06:10 | Postgres do not support tinyint? |