Inheritance and origin of rows

From: joerg(dot)troester(at)gmx(dot)net
To: pgsql-sql(at)postgresql(dot)org
Subject: Inheritance and origin of rows
Date: 1998-12-07 14:36:42
Message-ID: 7604.913041402@www.gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

In my database I created a table "partners" and two tables "individuals"
and "companies" which are inherited from "partners". Table "partners" has
columns "name", "address", "phone",...

Now I want to query any partner being an individual or company by a
statement like "select name,address,phone from partners*". For further proceeding
the information is needed which table (individuals or companies) any row is
taken from.

My question is:
* is there any possibility to retrieve this information from a system
table (e.g. the name of the table where a row/rowid resides in)
* or do I need a workaround like adding a column "tablename" into table
"partners"?

Thanks a lot for answering.
---
Sent through Global Message Exchange - http://www.gmx.net

Browse pgsql-sql by date

  From Date Subject
Next Message Fabio Mancinelli 1998-12-07 15:31:31 ' escape
Previous Message Herouth Maoz 1998-12-07 14:14:23 Re: [SQL] Howto format a float8 number?