From: Ross J. Reedstrom <reedstrm@rice.edu>
To: James Adams <pornstarbatman@hotmail.com>
Cc: Tomasz Myrta <jasiek@klaster.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: Selecting * from the base table but getting the inheriteds
Date: Fri, 1 Nov 2002 10:37:35 -0600
Message-ID: <20021101163735.GA443@wallace.ece.rice.edu> (raw)
In-Reply-To: <OE26Qx6QC3gYKOvN5wL0000a19a@hotmail.com>
References: <OE50hCLwHc9ny7BXx4X00000bd3@hotmail.com>
<3DBF92BF.4080506@klaster.net>
<OE26Qx6QC3gYKOvN5wL0000a19a@hotmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: reedstrm@rice.edu, pornstarbatman@hotmail.com, jasiek@klaster.net
Subject: Re: Selecting * from the base table but getting the inheriteds
In-Reply-To: <20021101163735.GA443@wallace.ece.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox