table as field type?? - Mailing list pgsql-sql

From David Diller
Subject table as field type??
Date
Msg-id 3.0.3.32.20001003105948.00ae7a70@pobox1.bbn.com
Whole thread Raw
Responses Re: table as field type??
List 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


pgsql-sql by date:

Previous
From: Michael Ansley
Date:
Subject: RE: Object features of pg
Next
From: Michael Ansley
Date:
Subject: RE: Object features of pg