Re: Boolean type storage format - Mailing list pgsql-general

From Marti Raudsepp
Subject Re: Boolean type storage format
Date
Msg-id CABRT9RB-OAPgfKu7Q3SczSSAjxn9d0E3bojPAvRZf_hK3EF1Ow@mail.gmail.com
Whole thread Raw
In response to Re: Boolean type storage format  (Raghavendra <raghavendra.rao@enterprisedb.com>)
List pgsql-general
On Wed, Oct 31, 2012 at 8:08 PM, Raghavendra
<raghavendra.rao@enterprisedb.com> wrote:
> False represented by zero bytes and True by 1 byte with value 1.

This is not true AFAIK. Both boolean TRUE and FALSE values require 1 byte.

A NULL value is zero bytes (though it still consumes 1 bit in the null
bitmap). This is true for all types, not just boolean.

Regards,
Marti


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: role does not exist
Next
From: "Kevin Burton"
Date:
Subject: Re: role does not exist