Skip site navigation (1) Skip section navigation (2)

Inheritance

From: Christophe Labouisse <labouiss(at)cybercable(dot)fr>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Inheritance
Date: 2000-05-30 10:16:25
Message-ID: m2k8gcny12.fsf@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-sql
I have a table (A) with a few "sibbling" tables (B and C for
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 ?


-- 
Le cinéma en Lumière : http://www.lumiere.org/
Fingerprint : 4721 651D D309 B302 93E4  5D73 CC52 DF3A E7C7 86CF

Responses

pgsql-sql by date

Next:From: Peter EisentrautDate: 2000-05-30 10:41:23
Subject: Re: Inheritance
Previous:From: omid omoomiDate: 2000-05-30 07:13:00
Subject: RE: 7.0 weirdness

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group