Re: Selecting * from the base table but getting the inheriteds

From: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
To: James Adams <pornstarbatman(at)hotmail(dot)com>
Cc: Tomasz Myrta <jasiek(at)klaster(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Selecting * from the base table but getting the inheriteds
Date: 2002-11-01 16:37:35
Message-ID: 20021101163735.GA443@wallace.ece.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2002-11-01 16:51:01 Re: FIFO Queue Problems
Previous Message Richard Huxton 2002-11-01 16:20:59 Re: FIFO Queue Problems