Re: Single character bitfields

Поиск
Список
Период
Сортировка
От Joshua Drake
Тема Re: Single character bitfields
Дата
Msg-id 20080820195644.742efb49@jd-laptop
обсуждение исходный текст
Ответ на Single character bitfields  ("Andrew Maclean" <andrew.amaclean@gmail.com>)
Ответы Re: Single character bitfields  (Ben <bench@silentmedia.com>)
Re: Single character bitfields  ("Andrew Maclean" <andrew.amaclean@gmail.com>)
Список pgsql-general
On Thu, 21 Aug 2008 12:40:29 +1000
"Andrew Maclean" <andrew.amaclean@gmail.com> 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).
>
> 1) Is char(1) the most efficient way to store these fields? If not
> what is better?

boolean?

Joshua D. Drake

--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate



В списке pgsql-general по дате отправления:

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