Return-Path: mao
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA20584; Wed, 24 Mar 93 10:11:50 -0800
Message-Id: <9303241811.AA20584@postgres.Berkeley.EDU>
From: Mike Olson <mao@postgres.Berkeley.EDU>
Subject: Re: define function
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
In-Reply-To: Your message of Wed, 24 Mar 1993 10:19:29 EST.
             <9303241519.AA19596@postgres.Berkeley.EDU> 
Date: Wed, 24 Mar 1993 10:12:41 -0800
From: Mike Olson <mao@postgres.Berkeley.EDU>

In message <9303241519.AA19596@postgres.Berkeley.EDU>you write:

> Define fucntion highpay (language="postquel", returntype=setof S)
> as retrieve (S.all) where S.salary>500  
> 
> I get an error message" "Syntax error at or near retrieve".  WHY??
> I am working on a project that is due soon and have had no luck
> with the define function command.  ANy help from anyone would be greatly apre
  +ciated.

because the function body must be enclosed in quotation marks.  see the
man page for define function.

reformulate as

define fucntion highpay (language="postquel", returntype=setof S)
    as "retrieve (S.all) where S.salary>500"