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