Thread

FUNCTIONS returning a record?

Pam Withnall <pamw@zoom.com.au> — 2000-11-03T00:08:45Z

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