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
