Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA19596; Wed, 24 Mar 93 07:19:07 -0800
Message-Id: <9303241519.AA19596@postgres.Berkeley.EDU>
From: vs4623@csc.albany.edu
Subject: define function
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: postgres@postgres.berkeley.edu
Date: Wed, 24 Mar 93 10:19:29 EST
X-Mailer: ELM [version 2.3 PL11]

Given the following command:
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 apreciated.


Vicki Schlierer
State University of New York at Albany
School of Business
Email: vs4623@sarah.albany.edu