Received: from po1.bbn.com (PO1.BBN.COM [192.1.50.38]) by hub.org (8.10.1/8.10.1) with ESMTP id e93EpQr93178 for ; Tue, 3 Oct 2000 10:51:26 -0400 (EDT) Received: from ddiller-2 (DHCP44.BBN.COM [128.89.27.144]) by po1.bbn.com (8.9.1/8.9.1) with SMTP id KAA04477 for ; Tue, 3 Oct 2000 10:51:25 -0400 (EDT) Message-Id: <3.0.3.32.20001003105948.00ae7a70@pobox1.bbn.com> X-Sender: ddiller@pobox1.bbn.com X-Mailer: QUALCOMM Windows Eudora Pro Version 3.0.3 (32) Date: Tue, 03 Oct 2000 10:59:48 -0400 To: pgsql-sql@postgresql.org From: David Diller Subject: table as field type?? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Archive-Number: 200010/25 I noticed that it's possible to have a table as a field type. For example: create table foo (val1 integer); create table bar (val2 foo); although the following doesn't work: create table bar2 (val2 foo[]); val2 in table bar ends up as an int4, designed for storing an oid from table foo. Is there a way to perform a query on bar that will return values from table foo (i.e., val1)? Thanks, David