Re: Single character bitfields

Поиск
Список
Период
Сортировка
От Ben
Тема Re: Single character bitfields
Дата
Msg-id 52ED6540-A057-4FCF-9870-C2E99AE57D64@silentmedia.com
обсуждение исходный текст
Ответ на Re: Single character bitfields  (Joshua Drake <jd@commandprompt.com>)
Ответы Re: Single character bitfields  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Bob Gobeille
Дата:
Сообщение: Re: plpgsql - sorting result set
Следующее
От: Bob Gobeille
Дата:
Сообщение: Re: plpgsql - sorting result set