Return-Path: pg_adm@postgres.berkeley.edu Received: by postgres.Berkeley.EDU (5.61/1.29) id AA21438; Tue, 29 Sep 92 01:25:20 -0700 Message-Id: <9209290825.AA21438@postgres.Berkeley.EDU> From: "M.S.Jackson" Subject: A few questions To: postgres@postgres.berkeley.edu Sender: pg_adm@postgres.berkeley.edu To: postgres (postgres bulletin board) <@sysa:postgres@edu.berkeley.postgres> Date: Tue, 29 Sep 92 9:27:24 MET DST X-Mailer: ELM [version 2.4dev PL32] I have two very straightforward questions: 1) The following script creates and uses a function to find the names of all highly paid employees. How would I alter it to find all the attributes of highly paid employees? spog > create EMP (name=text, salary=int4, age=int4,dept=char16) CREATE successful spog > append EMP(name="JOE",salary=1400,age=40,dept="shoe") APPEND 54708 successful spog > append EMP(name="Sam",salary=1200,age=29,dept="toy") APPEND 54720 successful spog > append EMP(name="Bill",salary=1200,age=29,dept="candy") APPEND 54721 successful spog > define function high_pay (language="postquel", returntype = setof EMP) as "retrieve (EMP.all) where EMP.salary > 1200" DEFINE successful spog > retrieve (names=name(high_pay())) JOE 2) The paper entitled "The POSTGRES Data Model" by Rowe and Stonebraker talks about relation attributes of type procedure. It gives an example of a column declared with type postquel. Has this idea been abandoned? -- ***************************************************************************** * * * Mike Jackson * * Reader in Software Engineering * * School of Computing and Information Technology * * University of Wolverhampton * * Wulfruna St. Phone: +44 902 322194 * * Wolverhampton WV1 1LY Fax: +44 902 322268 * * UNITED KINGDOM e-mail: cm1914@sysa.wlv.ac.uk * * * *****************************************************************************