Postgres Pro
Downloads
Home   >   mailing lists

Thread: nested table

nested table

From
"Peeter Smitt"
Date:
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 
 

Re: nested table

From
"Oliver Elphick"
Date:
"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.Elphick@lfix.co.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