Return-Path: paxson
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA22952; Tue, 8 Jun 93 14:43:51 -0700
Message-Id: <9306082143.AA22952@postgres.Berkeley.EDU>
From: "Caroline M. Paxson" <paxson@postgres.Berkeley.EDU>
Subject: Question On POSTGRES
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Date: Tue, 08 Jun 1993 14:34:27 -0700
From: "Caroline M. Paxson" <paxson@postgres.Berkeley.EDU>


Hi,
You ask how to use the function high_pay():

    
     define function high_pay
     (language = "postquel", returntype = set of EMP)
      as "retrieve (EMP.all) where EMP.salary > 50000" \g
    

You can say, for example,

   retrieve (name = name(high_pay()), sal = sal(high_pay()))

since high_pay() returns a set of tuples.  You CAN'T say

   retrieve (rich_guys = high_pay())

because you can't assign a complex type (namely the EMP tuples
returned by high_pay()) to a variable in the target list, YET.
I'm working on this now.


Carol Paxson
paxson@cs.berkeley.edu