Re: [GENERAL] this is what i meant

2006-01-16 Thread Tom Lane
"tschak" <[EMAIL PROTECTED]> writes: > Can I explicitly store 4 Bit (FIXED lenght) in a column without > "wasting" space? No. There is no provision in Postgres for data types occupying less than a byte. You'll need to think about merging those columns together. > Alright... so I do not need the

[GENERAL] this is what i meant

2006-01-16 Thread tschak
> If you don't need an OID, don't include it. IIRC, bit(4) will be 8 > bytes due to being variable length. If you want to store small numbers, > maybe smallint (2 bytes) is more useful. What I acually meant was the OID... Is smallint(2) the smalles size I can allocate? If I cannot allocate 4Bit o