| From: | Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> |
|---|---|
| To: | Christophe Labouisse <labouiss(at)cybercable(dot)fr> |
| Cc: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: Inheritance |
| Date: | 2000-05-30 10:41:23 |
| Message-ID: | Pine.GSO.4.02A.10005301239010.10362-100000@Leopard.DoCS.UU.SE |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff MacDonald | 2000-05-30 12:28:11 | 7.0 weirdness |
| Previous Message | Christophe Labouisse | 2000-05-30 10:16:25 | Inheritance |