----- Original Message -----
Sent: Tuesday, November 28, 2000 9:56 AM
Subject: Re: [GENERAL] nested table
----- Original Message -----
Sent: Thursday, January 18, 2001 7:23
PM
Subject: RE: [GENERAL] nested table
This is quite old usage (back to the Postgres95 days), and
because no-one has concentrated on the OO part of Postgres for quite a while,
it suffers a little from neglect. The semantics will take a while to
specify (does the data go into the foo table or the foo1 table; if it goes
into the foo table, do you use an oid to keep track of it, if not, then how do
you link one foo to many foo1's, or many foo's to one foo1, and how the hell
do you show this in a result set???), and I suspect that because it's not
standard SQL stuff, people will ignore it for a while still.
Cheers...
-----Original Message-----
From:
Oliver Elphick [mailto:[EMAIL PROTECTED]]
Sent: 18 January 2001 17:03
To: Peeter
Smitt
Cc: PostgreSQL General
Subject: Re: [GENERAL] 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
[EMAIL PROTECTED]
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
**********************************************************************
This
email and any files transmitted with it are confidential and
intended
solely for the use of the individual or entity to whom they
are addressed.
If you have received this email in error please notify
Nick West - Global
Infrastructure Manager.
This footnote also confirms that this email
message has been swept by
MIMEsweeper for the presence of computer
viruses.
www.mimesweeper.com
**********************************************************************
