Re: Single character bitfields - Mailing list pgsql-general

From Joshua Drake
Subject Re: Single character bitfields
Date
Msg-id 20080820195644.742efb49@jd-laptop
Whole thread Raw
In response to Single character bitfields  ("Andrew Maclean" <andrew.amaclean@gmail.com>)
Responses Re: Single character bitfields  (Ben <bench@silentmedia.com>)
Re: Single character bitfields  ("Andrew Maclean" <andrew.amaclean@gmail.com>)
List 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 by date:

Previous
From: "Andrew Maclean"
Date:
Subject: Single character bitfields
Next
From: Bob Gobeille
Date:
Subject: Re: plpgsql - sorting result set