nested table

From: "Peeter Smitt" <peeter(dot)smitt(at)online(dot)ee>
To: "PostgreSQL General" <pgsql-general(at)postgresql(dot)org>
Subject: nested table
Date: 2000-11-27 14:25:31
Message-ID: 00ca01c0587d$e63197e0$b6646ac2@miniraket
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I'm sure it has been already discused milion times but i can't find it from list archives.

Whats the syntax for inserting and quering tables with nested tables.

For example:

CREATE TABLE foo (attr1 int2, attr2 int2);

CREATE TABLE foo1 (id int4, name text, attr1 foo);

Now, how can i insert values into foo1?

Thanks

Peeter

Browse pgsql-general by date

  From Date Subject
Next Message Wade D. Oberpriller 2000-11-27 15:27:34 Re: PL/Perl on Solaris
Previous Message Paul Breen 2000-11-27 14:16:28 Re: Postgres 7 pgdump problems