Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3BA5E476DA5 for ; Fri, 1 Nov 2002 11:37:35 -0500 (EST) Received: from ece.rice.edu (ece.rice.edu [128.42.4.34]) by postgresql.org (Postfix) with ESMTP id C721A476DB8 for ; Fri, 1 Nov 2002 11:37:34 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by ece.rice.edu (Postfix) with SMTP id 0CF4468A9A; Fri, 1 Nov 2002 10:37:39 -0600 (CST) Received: from localhost (localhost [127.0.0.1]) by ece.rice.edu (Postfix) with ESMTP id 87B5568A97; Fri, 1 Nov 2002 10:37:38 -0600 (CST) Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154]) by ece.rice.edu (Postfix) with ESMTP id 8F55768A99; Fri, 1 Nov 2002 10:37:35 -0600 (CST) Received: from reedstrm by wallace.ece.rice.edu with local (Exim 3.36 #1 (Debian)) id 187enf-00007s-00; Fri, 01 Nov 2002 10:37:35 -0600 Date: Fri, 1 Nov 2002 10:37:35 -0600 From: "Ross J. Reedstrom" To: James Adams Cc: Tomasz Myrta , pgsql-sql@postgresql.org Subject: Re: Selecting * from the base table but getting the inheriteds Message-ID: <20021101163735.GA443@wallace.ece.rice.edu> Mail-Followup-To: "Ross J. Reedstrom" , James Adams , Tomasz Myrta , pgsql-sql@postgresql.org References: <3DBF92BF.4080506@klaster.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4i X-Virus-Scanned: by AMaViS snapshot-20020300 X-DCC--Metrics: ece.rice.edu 1067; Body=1 Fuz1=1 Fuz2=1 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200211/9 X-Sequence-Number: 10151 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