Received: from mail.enterprise.net (mail.enterprise.net [194.72.192.18]) by hub.org (8.10.1/8.10.1) with ESMTP id e6R95QA26445 for ; Thu, 27 Jul 2000 05:05:26 -0400 (EDT) Received: from linda.lfix.co.uk (cmax07-235.enterprise.net [212.161.113.235]) by mail.enterprise.net (8.8.5/8.8.5) with ESMTP id KAA08653; Thu, 27 Jul 2000 10:05:24 +0100 (GMT/BST) Received: from lfix.co.uk (olly@localhost [127.0.0.1]) by linda.lfix.co.uk (8.11.0.Beta1/8.11.0.Beta1/Debian 8.11.0-1) with ESMTP id e6R91pA23448; Thu, 27 Jul 2000 10:01:51 +0100 Message-Id: <200007270901.e6R91pA23448@linda.lfix.co.uk> X-Authentication-Warning: linda.lfix.co.uk: Host olly@localhost [127.0.0.1] claimed to be lfix.co.uk X-Mailer: exmh version 2.1.1 10/15/1999 (debian) X-URL: http://www.lfix.co.uk/oliver X-face: "xUFVDj+ZJtL_IbURmI}!~xAyPC"Mrk=MkAm&tPQnNq(FWxv49R}\>0oI8VM?O2VY+N7@F- KMLl*!h}B)u@TW|B}6 cc: pgsql-sql@postgresql.org Subject: Re: Classes, Inheritance, and Children In-reply-to: Message from Thomas Swan of Thu, 27 Jul 2000 02:06:51 EST. <4.3.2.7.2.20000727014844.020d4d48@sunset.backbone.olemiss.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Thu, 27 Jul 2000 10:01:50 +0100 From: "Oliver Elphick" X-Archive-Number: 200007/251 Thomas Swan wrote: >I think I may have asked this before... If I did I'm sorry, but maybe this >attempt, assuming a prior one, may be a little more clear. > >create table foo (id int8); >create table bar1 (name text) inherits (foo); >create table bar2 (data text) inherits (foo); >create table hybrid ( ) inherits (bar1, bar2); > >INSERT INTO foo VALUES (1); >INSERT INTO bar1 VALUES (2,'myname'); >INSERT INTO bar2 VALUES (3,'mydata'); >INSERT INTO hybrid VALUES (4,'morename','moredata'); > > >I want to do a SELECT * FROM foo*; but I only get the 'id' column as in : > >id >--- > 1 > 2 > 3 > 4 This is correct in object-oriented theory. foo only knows about its own features; it does not know about additional features of its descendants, nor should it. >What would be the query to get the following table or a magical way to >expand children? > >I had originally hoped that SELECT * FROM foo* would yield the following, >but it's not so. > >id | name | data >---+------------+------------- > 1 | null | null > 2 | 'myname' | null > 3 | null | 'mydata' > 4 | 'morename' | 'moredata' You need to use a UNION of the four tables, with nulls supplied where necessary: select * from hybrid -- specify first to establish the -- column types union select id, null, null from foo union select id, name, null from bar1 union select id, null, data from bar2; Unfortunately, you can't make this a view, because views of unions are not yet supported. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "But the wisdom that is from above is first pure, then peaceable, gentle, and easy to be intreated, full of mercy and good fruits, without partiality, and without hypocrisy." James 3:17