Re: Inheritance - Mailing list pgsql-novice

From Tom Lane
Subject Re: Inheritance
Date
Msg-id 2188.1103600726@sss.pgh.pa.us
Whole thread Raw
In response to Inheritance  (Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my>)
List pgsql-novice
Hasnul Fadhly bin Hasan <hasnulfadhly.h@mimos.my> writes:
> I'm just wondering, what real benefit does inheritance have?  When i
> create two tables, one inherited from the other,
> does that mean i have two tables with same duplicate data or actually
> they are joined in the back end?

It's more like an implicit UNION ALL.  There's no duplication, but when
you specify a SELECT/UPDATE/DELETE over the parent table, the child
table is implicitly processed as well.

            regards, tom lane

pgsql-novice by date:

Previous
From: Hasnul Fadhly bin Hasan
Date:
Subject: Inheritance
Next
From: Keith Worthington
Date:
Subject: Re: CAST and timestamp