HI,
I want to return a record from a FUNCTION in plpgsql procedural language.
There are very few examples to go by.
It doesn't accept RETURN RECORD.
I've tried
making a record in the declare section and returning OPAQUE.

TYPE temp IS RECORD
(id int4,
name varchar(50),
);
It gives the error java.sql.SQLException: ERROR:  typeidTypeRelid: Invalid
type - oid = 0
does someone have the answer?
Thanks, Pam

Fri, 3 Nov 2000 11:08:45 +1100 
Pam Withnall <Pamw@zoom.com.au>
FUNCTIONS returning a record?