Postgres Pro
Downloads
Home   >   mailing lists

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

From Mike Christensen
Subject Re: Boolean type storage format
Date
Msg-id CABs1bs15f_cnEbkDrnt89fnuCM0QbS0HqroAmkjUCw9m8Tq13Q@mail.gmail.com
Whole thread Raw
In response to Re: Boolean type storage format  (Raghavendra <raghavendra.rao@enterprisedb.com>)
Responses Re: Boolean type storage format
List pgsql-general
Tree view
It would also matter what columns were next to it, correct?

For example, if you had 4 bools in a row, that could also be 1 byte..

On Wed, Oct 31, 2012 at 11:08 AM, Raghavendra <raghavendra.rao@enterprisedb.com> wrote:
On Wed, Oct 31, 2012 at 8:52 PM, Alexander Gataric <gataric@usa.net> wrote:
What is the data physically stored as for boolean type? I know that it is one byte but is it char, int, or something else?


False represented by zero bytes and True by 1 byte with value 1.

---
Regards,
Raghavendra
EnterpriseDB Corporation


pgsql-general by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: dropdb breaks replication?
Next
From: Tom Lane
Date:
Subject: Re: dropdb breaks replication?