Re: Single character bitfields - Mailing list pgsql-general

From Ben
Subject Re: Single character bitfields
Date
Msg-id 52ED6540-A057-4FCF-9870-C2E99AE57D64@silentmedia.com
Whole thread Raw
In response to Re: Single character bitfields  (Joshua Drake <jd@commandprompt.com>)
Responses Re: Single character bitfields
List pgsql-general
On Aug 20, 2008, at 7:56 PM, Joshua Drake wrote:

>> I have a large database and I want to have several fields (among
>> many)
>> that are single character fields (in fact they are bitfields).
>>
> boolean?

Out of curiosity, does postgres collapse multiple boolean columns to a
bitfield internally? In other words, I guess I assume a single boolean
column will always take 1 byte of space... but if I have 8 boolean
columns, will they all fit into that 1 byte?

pgsql-general by date:

Previous
From: Bob Gobeille
Date:
Subject: Re: plpgsql - sorting result set
Next
From: Bob Gobeille
Date:
Subject: Re: plpgsql - sorting result set