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
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? |