Re: Single character bitfields

From: Joshua Drake <jd(at)commandprompt(dot)com>
To: a(dot)maclean(at)cas(dot)edu(dot)au
Cc: andrew(dot)amaclean(at)gmail(dot)com, General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Single character bitfields
Date: 2008-08-21 02:56:44
Message-ID: 20080820195644.742efb49@jd-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 21 Aug 2008 12:40:29 +1000
"Andrew Maclean" <andrew(dot)amaclean(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Maclean 2008-08-21 03:29:39 Re: Single character bitfields
Previous Message Andrew Maclean 2008-08-21 02:40:29 Single character bitfields