[GENERAL] nested table

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

Reply via email to