Home > mailing lists

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

From	Raghavendra
Subject	Re: Boolean type storage format
Date	October 31, 2012 21:08:58
Msg-id	CA+h6AhjniuEm2ygQfQOw7tQ4TOwrm1-Mrw7kyCANzBdBM-xLJA@mail.gmail.com Whole thread Raw
In response to	Boolean type storage format ("Alexander Gataric" <gataric@usa.net>)
Responses	Re: Boolean type storage format (Mike Christensen <mike@kitchenpc.com>) Re: Boolean type storage format (Marti Raudsepp <marti@juffo.org>)
List	pgsql-general

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

Blog: http://raghavt.blogspot.com/

pgsql-general by date:

Previous

From: Edson Richter
Date: 31 October 2012, 21:01:48
Subject: Re: dropdb breaks replication?

Next

From: Lonni J Friedman
Date: 31 October 2012, 21:09:49
Subject: Re: dropdb breaks replication?