Re: size of NULL field?

From: dalgoda(at)ix(dot)netcom(dot)com (Mike Castle)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: size of NULL field?
Date: 2002-04-18 01:09:21
Message-ID: hr2l9a.ldh.ln@thune.mrc-home.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <200204151933(dot)g3FJXT912721(at)candle(dot)pha(dot)pa(dot)us>,
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
>Oh, I didn't realize the size of the NULL bitmask was zero if no nulls
>exist. Nice.

So, how does the row know if the NULL bitmask exists or not? I'm guessing
there's a structure per row somewhere that has as at least one of it's
members, a bit on whether a NULL bitmask exists or not?

If all of the members of a row become non-NULL, does the NULL bitmask go
away?

mrc

--
Mike Castle dalgoda(at)ix(dot)netcom(dot)com www.netcom.com/~dalgoda/
We are all of us living in the shadow of Manhattan. -- Watchmen
fatal ("You are in a maze of twisty compiler features, all different"); -- gcc

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2002-04-18 02:25:04 Re: Date precision problem
Previous Message pgsql-gen Newsgroup (@Basebeans.com) 2002-04-18 00:40:01 Re: Poor performance with "large" table.