Message-ID: <3DBF92BF.4080506@klaster.net>
Date: Wed, 30 Oct 2002 09:05:19 +0100
From: Tomasz Myrta <jasiek@klaster.net>
User-Agent: Mozilla/5.0 (Windows; U; Win 9x 4.90; PL; rv:1.1) Gecko/20020826
MIME-Version: 1.0
To: James Adams <pornstarbatman@hotmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Selecting * from the base table but getting the inheriteds
References: <OE50hCLwHc9ny7BXx4X00000bd3@hotmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

Uz.ytkownik James Adams napisa?:
> Hello,
>  
> I have a "baseTable".  I have a number of decendantTables that INHERIT 
> from the base table. 
>  
> I want to do somthing like
>  
> =>select * from baseTable;
>  
> But I want it to return the data in the all the descendant tables along 
> with the extra column that they contain.  How do I do this?
>  

select
  *,
  cast(null as varchar) as another_field1,
  cast(null as int4) as another_field2
from only basetable
union
select
  *
from descent_table

Isn't it easier to just create baseTable with the same columns as 
descent tables (and fill them with nulls)?

Tomasz Myrta