Re: Single character bitfields

On Thu, Aug 21, 2008 at 12:56 PM, Joshua Drake <jd(at)commandprompt(dot)com> wrote:
> 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
>
>
>

I wouldn't be happy doing this because I prefer treating boolean data
types as only TRUE or FALSE.

Is char(1) one byte in size?

--
___________________________________________
Andrew J. P. Maclean
Centre for Autonomous Systems
The Rose Street Building J04
The University of Sydney 2006 NSW
AUSTRALIA
Ph: +61 2 9351 3283
Fax: +61 2 9351 7474
URL: http://www.acfr.usyd.edu.au/
___________________________________________