Re: nested table

"Peeter Smitt" wrote:
>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?

I asked this same question a couple of weeks back. Apparently the facility
to do this is no longer present in PostgreSQL.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"For the eyes of the LORD run to and fro throughout the
whole earth, to show himself strong in the behalf of
them whose heart is perfect toward him..."
II Chronicles 16:9