Re: Postgres do not support tinyint?
Adrian Klaver <adrian.klaver@aklaver.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Igor Korot <ikorot01@gmail.com>,
"pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Date: 2025-01-08T05:20:56Z
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.klaver@aklaver.com