Return-Path: owner-postman 
Delivery-Date: Mon, 16 May 94 10:43:36 -0700
Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id HAA08848 for postgres-redist; Mon, 16 May 1994 07:05:21 -0700
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199405161405.HAA08848@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from irafs1.ira.uka.de (irafs1.ira.uka.de [129.13.10.100]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id HAA08838 for <postgres@nobozo.cs.berkeley.edu>; Mon, 16 May 1994 07:05:19 -0700
Received: from irafs2.ira.uka.de (actually irafs2) by irafs1 with SMTP (PP);
          Mon, 16 May 1994 16:00:40 +0200
Received: from iras4.ira.uka.de by irafs2.ira.uka.de with SMTP (PP) 
          id <17954-0@irafs2.ira.uka.de>; Mon, 16 May 1994 16:04:32 +0200
To: postgres@postgres.Berkeley.EDU
Subject: Class of a tupel within inheritance hierachy
Date: Mon, 16 May 1994 16:03:56 +0200
From: Gerhard Daub <daub@ira.uka.de>
Message-ID: <"irafs2.ira.957:16.04.94.14.04.35"@ira.uka.de>
Resent-To: postgres-redist@postgres.Berkeley.EDU
Resent-Date: Mon, 16 May 94 07:05:21 -0700
Resent-XMts: smtp


Hi everybody!


Is there a query to find out to which relation a tupel belongs in an
inheritance hierachy?



Example:

create father (...)
create son1 (...) inherits (father)
create son2 (...) inherits (father)

retrieve (tupel.all) from tupel in father* 
where ....



How can I determine whether 'tupel' belongs to father, son1 or son2 ?


Thanks for help!

Gerhard


P.S.: Sorry. I remember that this question was issued recently. But I
deleted the mail. :-(

===============================================================================
    To add/remove yourself from the POSTGRES mailing list: send mail with 
    the subject line ADD or DEL to "postgres-request@postgres.Berkeley.EDU"

    If this fails, send mail to "post_questions@postgres.Berkeley.EDU" and
    a human will deal with it.  DO NOT post to the "postgres" mailing list.
===============================================================================