Received: from gabuzo.dyn.cheapnet.net (IDENT:postfix@r190m17.cybercable.tm.fr [195.132.190.17]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA80406 for ; Tue, 30 May 2000 06:16:27 -0400 (EDT) (envelope-from christophe.labouisse@dial.oleane.com) Received: by gabuzo.dyn.cheapnet.net (Postfix, from userid 501) id 25B6018312; Tue, 30 May 2000 12:16:25 +0200 (CEST) To: pgsql-sql@postgreSQL.org Subject: Inheritance Mime-Version: 1.0 (generated by tm-edit 1.5) Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit From: Christophe Labouisse Date: 30 May 2000 12:16:25 +0200 Message-ID: Lines: 9 X-Mailer: Gnus v5.6.45/XEmacs 21.1 - "Bryce Canyon" X-Archive-Number: 200005/190 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