table as field type??

From: David Diller <ddiller(at)bbn(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: table as field type??
Date: 2000-10-03 14:59:48
Message-ID: 3.0.3.32.20001003105948.00ae7a70@pobox1.bbn.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tod McQuillin 2000-10-03 15:37:37 RE: Object features of pg
Previous Message Michael Ansley 2000-10-03 14:52:50 RE: Object features of pg