From: Peter Eisentraut <e99re41@DoCS.UU.SE>
To: Christophe Labouisse <labouiss@cybercable.fr>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: Inheritance
Date: Tue, 30 May 2000 12:41:23 +0200 (MET DST)
Message-ID: <Pine.GSO.4.02A.10005301239010.10362-100000@Leopard.DoCS.UU.SE> (raw)
In-Reply-To: <m2k8gcny12.fsf@localhost.localdomain>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: e99re41@DoCS.UU.SE, labouiss@cybercable.fr
Subject: Re: Inheritance
In-Reply-To: <Pine.GSO.4.02A.10005301239010.10362-100000@Leopard.DoCS.UU.SE>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox