Re: Efficient Boolean Storage

Csaba Nagy wrote:
> BTW, is or is not using Postgres a string to store the bit data types ? I
> have seen a few people asking this on the list, but no straight answer as of
> yet... the docs really don't mention this aspect.

Use the source ;-)

From varbit.c

/*----------
* attypmod -- contains the length of the bit string in bits, or for
* varying bits the maximum length.
*
* The data structure contains the following elements:
* header -- length of the whole data structure (incl header)
* in bytes. (as with all varying length datatypes)
* data section -- private data section for the bits data structures
* bitlength -- length of the bit string in bits
* bitdata -- bit string, most significant byte first
*
* The length of the bitdata vector should always be exactly as many
* bytes as are needed for the given bitlength. If the bitlength is
* not a multiple of 8, the extra low-order padding bits of the last
* byte must be zeroes.
*----------
*/

Joe