Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA06521; Sun, 7 Feb 93 15:26:08 -0800
Date: Sun, 7 Feb 93 15:26:08 -0800
Message-Id: <9302072326.AA06521@postgres.Berkeley.EDU>
From: witr@rwwa.COM
Subject: How to get all info from all subclasses?
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Content-Type: text
Content-Length: 726

Suppose one wants to retrieve *all* fields from *all* subclasses
of a class.  How does one do that?

If I do ``retrieve (t.all) from t in TOOL*'' in the monitor only the
TOOL fields are printed, even though an instance is retrieved for all
of the subclasses.

If I do ``retrieve portal p (t.all) from t in TOOL*'' I only get 1
group as reported by PQngroups.  The documentation sortof states that
I *should* get as many groups as there are subclasses of TOOL.

In a related question, referring to the above query, how do you find
out what class an instance belongs to?

---
 Robert Withrow, Tel: +1 617 598 4480, Fax: +1 617 598 4430, Net: witr@rwwa.COM
 R.W. Withrow Associates, 21 Railroad Ave, Swampscott MA 01907-1821 USA