Re: Inheritance

On 30 May 2000, Christophe Labouisse wrote:

> I have a table (A) with a few "sibbling" tables (B and C for

You probably mean "child" tables.

> instance). When I make the following query : select id from A* where
> [condition] pgsql returns ids taken from A, B or C (which is what I
> want). Is there a way to know to what table the id actually belong ?

No. We're kind of pondering a way to solve this. However, according to the
SQL99 data model, the row is shared between A and B or C respectively, so
when you select from a* then you get rows from "a", period. I know this
doesn't help in practice, though.

-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden