Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA13179; Thu, 20 Feb 92 00:57:54 -0800
Message-Id: <9202200857.AA13179@postgres.Berkeley.EDU>
From: schoenbe@ibr.cs.tu-bs.de (Ullrich Schoenbeck)
Subject: problem with append
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: postgres@postgres.Berkeley.EDU
Date: Thu, 20 Feb 92 9:58:58 MET
Cc: schoenw@achill (Juergen Schoenwaelder)

Hi !

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 ?

One can gratify me by sending an example with the correct syntax.
Thanks, 


Ullrich Schoenbeck
schoenbe@ibr.cs.tu-bs.de