Re: Bit string storage space? - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Bit string storage space?
Date
Msg-id 3E55CDEC.D1C44066@cvc.net
Whole thread Raw
In response to Bit string storage space?  (Stephen Robert Norris <srn@commsecure.com.au>)
List pgsql-general
1 byte equals 8 bits in the bit string. Add 4 bytes minimum for the
'size_of' value for the field.

Example:

B'11011011010101101' 17 bits

(17 % 8) + 1 (round up) + 4 ( for size ) = 7 bytes to store 17 bits.
--

Carpe Dancem ;-)
-----------------------------------------------------------------
Remember your friends while they are alive
-----------------------------------------------------------------
                         Sincerely, Dennis Gearon

pgsql-general by date:

Previous
From: Neil Conway
Date:
Subject: Re: Authentication to run pg_dump automatically
Next
From: Neil Conway
Date:
Subject: Re: continuous data from stdin