Skip site navigation (1) Skip section navigation (2)

Question:

From: "Patricia Mitchell" <patricia-mitche(at)excite(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Question:
Date: 2008-06-10 14:18:05
Message-ID: 20080610141805.9D0D0B57F6@xprdmxin.myway.com (view raw or flat)
Thread:
Lists: pgsql-novice

When a table is a supertable of other tables and a subtable consists of identical rows of the supertable and then you do a query on the supertable, would the identical rows be displayed twice since the rows appear in the supertable and the subtable?

When you inherit a table, are you inheriting the table definition/structure or are you inheriting the data as well?  

If the answer is only the table structure, then please ignore the question above?

Thanks.




_______________________________________________
Join Excite! - http://www.excite.com
The most personalized portal on the Web!



Responses

pgsql-novice by date

Next:From: Mark RobertsDate: 2008-06-10 16:49:48
Subject: Re: Question:
Previous:From: Obe, ReginaDate: 2008-06-06 18:34:43
Subject: Re: Problem in Multiple table Join

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group