Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id PAA12812 for postgres-dist; Wed, 8 Dec 1993 15:49:13 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199312082349.PAA12812@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from elysium.CS.Berkeley.EDU (elysium.CS.Berkeley.EDU [128.32.149.6]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id PAA12803 for <postgres@nobozo.CS.Berkeley.EDU>; Wed, 8 Dec 1993 15:49:12 -0800
Received: from localhost (paxson@localhost) by elysium.CS.Berkeley.EDU (8.6.4/8.1B) id PAA15085; Wed, 8 Dec 1993 15:49:06 -0800
Message-Id: <199312082349.PAA15085@elysium.CS.Berkeley.EDU>
To: Anitha Panapakkam <anitha@umriscae.isc.umr.edu>
cc: postgres@postgres.Berkeley.EDU
Date: Wed, 08 Dec 1993 15:49:04 -0800
From: "Caroline M. Paxson" <paxson@postgres.Berkeley.EDU>
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Wed, 08 Dec 93 15:49:13 -0800
Resent-XMts: smtp


You write

>how do i retrieve the entire tuple the func1(EMP) returns

Unfortunately there is no way to do this in Postgres yet.  You can't
currently assign an entire tuple to an instance variable (like your "ds"
variable).  We are working on a solution for the next release.  In the
meantime, you will have to run the function multiple times, i.e.

retrieve (E.all, ds = name(func1(E)), dx = salary(func1(E)))
       from E in EMP
       where E.id = "100"

This assumes there is only one employee with id = 100.  All bets are
off otherwise.

Carol Paxson
Postgres group
U.C. Berkeley