Return-Path: pg_adm@postgres.berkeley.edu
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA03512; Thu, 12 Dec 91 19:09:13 -0800
Message-Id: <9112130309.AA03512@postgres.Berkeley.EDU>
From: Jason Wilson <jay@pandanus.cs.ntu.edu.au>
Subject: Why doesnt this work
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
To: postgres@postgres.Berkeley.EDU
Date: Fri, 13 Dec 91 12:39:10 CST
X-Mailer: ELM [version 2.3 PL11]

We are running version 3.1 of postgres, and when we do the following:

create EMP (name = char[12],salary=float8,age=int4,dept=char[12])
define function no_pay(language = "postquel", returntype = EMP) arg is  (float8 ) as retrieve (EMP.all) where EMP.salary = $1

with appropiate "\g" on the ends the following is reported:

Query sent to backend is "define function no_pay(language = "postquel", returntype = EMP)  arg is  (float8 ) as     retrieve (EMP.all) where EMP.salary = $1 "
NOTICE:Dec 13 11:04:09:RelationBuildDesc: (relation name float8) nonexistent
 
WARN:Dec 13 11:04:09:heap_openr on float8 failed

Any help would be greatly appreciated.

-------------------------------------------------------------------------------
Jason 'Jay' Wilson                                      jay@pandanus.ntu.edu.au