Postgres Pro
Downloads
Home   >   mailing lists

Re: Selecting * from the base table but getting the inheriteds - Mailing list pgsql-sql

From Ross J. Reedstrom
Subject Re: Selecting * from the base table but getting the inheriteds
Date
Msg-id 20021101163735.GA443@wallace.ece.rice.edu
Whole thread Raw
In response to Re: Selecting * from the base table but getting the inheriteds  ("James Adams" <pornstarbatman@hotmail.com>)
List pgsql-sql
Tree view 
On Wed, Oct 30, 2002 at 10:25:17AM +0100, James Adams wrote:
> Yea it would be easier to have everything in one table filling unused with
> nulls, but I was trying to avoid that because of the wasted space.
> But I think I'll do it that way after all  :~]
> Thanks for your help

Don't fret too much about the wasted space: NULL fields set a bit in
a bitmask in the header of the on-disk tuple, so they take up _no_
storage at all.

Ross

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: FIFO Queue Problems
Next
From: Bruno Wolff III
Date:
Subject: Re: FIFO Queue Problems