Re: BUG #2802: Feature request: tinyint and unsigned types
Bruno Wolff III <bruno@wolff.to>
From: Bruno Wolff III <bruno@wolff.to>
To: Albert Strasheim <fullung@gmail.com>
Cc: pgsql-bugs@postgresql.org
Date: 2006-12-04T22:11:17Z
Lists: pgsql-bugs
On Fri, Dec 01, 2006 at 20:41:32 +0000, Albert Strasheim <fullung@gmail.com> wrote: > > Description: Feature request: tinyint and unsigned types You can already use "char" to store 1 byte values, though unless there are several of these in a row, you won't save any space because of alignment. There are also people working on a nicer way to do enum, that looked to be relatively space efficient (though I don't remember if there was going to be a way to store small sets using only one byte). This got discussed a while ago, but didn't make it into 8.2 (as far as I can tell). Depending on what you are really trying to do, bit strings may also be useful for you. While individual bit string columns aren't going to fit in one byte, you can pack bits together which might be a saving over all. Postgres is extensible, so you can add your one 1 byte types without doing too much work.