Home > mailing lists

nested table - Mailing list pgsql-general

From	Peeter Smitt
Subject	nested table
Date	January 18, 2001 12:24:25
Msg-id	00ca01c0587d$e63197e0$b6646ac2@miniraket Whole thread Raw
Responses	Re: nested table
List	pgsql-general

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

From: "Diehl, Jeffrey"
Date: 18 January 2001, 12:24:22
Subject: Help with query. (*)

From: "Michelle Anderson"
Date: 18 January 2001, 12:35:14
Subject: referential integrity