Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA18200; Thu, 20 Feb 92 10:37:09 -0800
Message-Id: <9202201837.AA18200@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: problem with append
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Reply-To: mer@postgres.berkeley.edu
In-Reply-To: Your message of "Thu, 20 Feb 92 09:58:58 +0700."
             <9202200857.AA13179@postgres.Berkeley.EDU> 
Date: Thu, 20 Feb 92 10:36:53 PST

you write:

> I have a problem by inserting values in a class.
> 
> First I create the following bases:
> 
>   create PERSON (name=text, firstname=text, address=text, telno=text)
>   create GUEST () inherits (PERSON)
>   create COLLEAGUE (telno2=text, position=text) inherits (PERSON)
>   create INSTITUTE (name=text, address=text, manager=COLLEAGUE)
> 
> I think that's ok.
> 
> Now I insert tuples to the relation COLLEAGUE. That works fine, too.
> The next thing I want to do is appending tuples to the relation INSTITUTE.
> 
> My problem is assigning a value to the attribut manager.
> Can I do that by using the command append or do I need an additional postquel
 + function ?

The problem is that there currently isn't very much support for complex
types.  You can't use complex attributes as defined above.  There's just no
way to append data to them.  The only complex type manipulation supported is
that provided by postquel functions.  This situation is due to improve
markedly in version 4.


Jeff Meredith
mer@postgres.berkeley.edu