Hello
I am not an expert for database but rarely design database for Web and IVR
applications.
Today I wonder if there is any practical advantage of inheritance of Tables.
Lets take the same example that is commonly referred.
CREATE TABLE cities (
name text,
population float,
altitude int -- in feet
);
CREATE TABLE capitals (
state char(2)
) INHERITS (cities);
Capital table inherit attributes from Cities but no data. I am
confused with concept of inheritance in postgres.
In These tables what i was supposing is inheritence as that in JAVA. but its
seems to be a different scene.
Can some one Please compare inheritence in JAVA and Postgresql OR make me
clear about for what inheritance is introduced in Postgres.
--
Best Regards
Shakeel Abbas
