Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA02482; Tue, 25 Jun 91 16:31:51 -0700
Date: Tue, 25 Jun 91 16:31:51 -0700
Message-Id: <9106252331.AA02482@postgres.Berkeley.EDU>
From: klein@imasun.lbl.gov (Gregory Klein)
Subject: composite objects
To: postgres@postgres.berkeley.edu

In the Postgres tutorial, the following composite object was defined:

create EMP(name=c12,salary=float8,age=int4,dept=c12,manager=EMP)

and attributes were appended to the object using

append to EMP (name="Sam",salary=1000,age=40,dept="shoe",
manager=mgr-lookup("shoe"))

where mgr-lookup was defined as the function by

define function mgr-lookup(c12) returns EMP as
retrieve (EMP.all) where EMP.name=DEPT.manager and DEPT.name=$1

Since Postgres 2.1 does not appear to be able to define this sort of
function, is there a way to populate composite objects?

Thanks,
Greg Klein