Return-Path: mao
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA05484; Mon, 8 Mar 93 13:06:16 -0800
Message-Id: <9303082106.AA05484@postgres.Berkeley.EDU>
From: <mao@postgres.berkeley.edu>
Subject: Re: dumb question?
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Mon, 08 Mar 93 12:01:32 PST.
             <9303082001.AA04956@postgres.Berkeley.EDU> 
Date: Mon, 08 Mar 93 13:05:45 PST

In message <9303082001.AA04956@postgres.Berkeley.EDU> you write:

> I have a (probably) dumb question. How do I actually use a 
> function that returns a class given an scalar argument?
> 
> eg:	define function large_pay
> 	(language = "postquel", returntype = setof emp)
> 	arg is (int4)
> 	as "retrieve (emp.all) where emp.salary > $1" \g
> 
> I've tried
> 
> 	retrieve (emp.name, emp.salary) where large_pay(300) \g

retrieve (who = name(large_pay(300)))

					mike