Fw: nested table - Mailing list pgsql-general

From Peeter Smitt
Subject Fw: nested table
Date
Msg-id 035301c05916$570df920$b6646ac2@miniraket
Whole thread Raw
List pgsql-general
 
----- Original Message -----
Sent: Tuesday, November 28, 2000 9:56 AM
Subject: Re: [GENERAL] nested table

If it's so then you can't say PostgreSQL is ORDBMS, or can you? Unfortunately i don't know how Oracle handles its nested table but i'm sure it does.
 
Peeter
----- 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:olly@lfix.co.uk]
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                                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

**********************************************************************
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
**********************************************************************

pgsql-general by date:

Previous
From: Tony Grant
Date:
Subject: Re: initdb doesn not create template1 database
Next
From: Guillaume Lémery
Date:
Subject: .so functions and SQL queries