Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 483C3475F53 for ; Tue, 29 Oct 2002 17:39:21 -0500 (EST) Received: from hotmail.com (oe50.pav2.hotmail.com [64.4.36.22]) by postgresql.org (Postfix) with ESMTP id A9425475E5E for ; Tue, 29 Oct 2002 17:39:20 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 29 Oct 2002 14:39:22 -0800 X-Originating-IP: [217.168.173.114] From: "James Adams" To: Subject: Selecting * from the base table but getting the inheriteds columns Date: Tue, 29 Oct 2002 23:37:46 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003B_01C27FA4.2F5B1E60" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: X-OriginalArrivalTime: 29 Oct 2002 22:39:22.0621 (UTC) FILETIME=[06D78AD0:01C27F9C] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/395 X-Sequence-Number: 10112 This is a multi-part message in MIME format. ------=_NextPart_000_003B_01C27FA4.2F5B1E60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I have a "baseTable". I have a number of decendantTables that INHERIT from= the base table.=20=20 I want to do somthing like =3D>select * from baseTable; But I want it to return the data in the all the descendant tables along wit= h the extra column that they contain. How do I do this? please help many thanks for your time James ------=_NextPart_000_003B_01C27FA4.2F5B1E60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
 
I have a "baseTable".  I have a = number=20 of decendantTables that INHERIT from the base table. =20
 
I want to do somthing like
 
=3D>select * from baseTable;
 
But I want it to return the data in the al= l the=20 descendant tables along with the extra column that they contain.  How = do I=20 do this?
 
please help
 
many thanks for your time
 
James
 
 
------=_NextPart_000_003B_01C27FA4.2F5B1E60--