Thread: BIT STRINGS

BIT STRINGS

From

Dennis Gearon

Date:

17 February 2003, 15:10:39

I could not find out how bit strings are stored on this list, or by searching the archives via the
PostgreSQL website. So I finally searched http://marc.theaimsgroup.com/ and found them. I am
putting this information here to make it easier to search for on the postgres weg site.

The article is:

    http://marc.theaimsgroup.com/?l=postgresql-general&m=103902413213999&w=2

The date is:

    2002-12-04 17:39:41

The author is:

    Joe Conway

The answer is, (quoted from pgsql source code):

       *      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.