Re: Single character bitfields

From: Ben <bench(at)silentmedia(dot)com>
To: Joshua Drake <jd(at)commandprompt(dot)com>
Cc: General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Single character bitfields
Date: 2008-08-21 03:32:22
Message-ID: 52ED6540-A057-4FCF-9870-C2E99AE57D64@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Gobeille 2008-08-21 04:11:51 Re: plpgsql - sorting result set
Previous Message Andrew Maclean 2008-08-21 03:29:39 Re: Single character bitfields