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

From Christophe Pettus
Subject Re: Postgres do not support tinyint?
Date
Msg-id 11AA76D0-CAFE-4A17-BCCF-50520CCDF47F@thebuild.com
Whole thread Raw
In response to Re: Postgres do not support tinyint?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Postgres do not support tinyint?
List pgsql-general

> On Jan 7, 2025, at 22:44, David G. Johnston <david.g.johnston@gmail.com> wrote:
>
> You suggest a type with a minimum size of 6 bytes when the complaint is that the otherwise acceptable 2 byte data
typeis too large? 

Although it's not clear from the OP's question, if there are going to be a significant number of these 3-bit fields,
packingthem into a bitstring might be a way forward.  It's a good solution for tables with a ton of booleans. 


pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Postgres do not support tinyint?
Next
From: Tom Lane
Date:
Subject: Re: Postgres do not support tinyint?