FUNCTIONS returning a record?
Pam Withnall <pamw@zoom.com.au>
From: Pam Withnall <Pamw@zoom.com.au>
To: "'pgsql-hackers@postgresql.org'" <pgsql-hackers@postgresql.org>
Date: 2000-11-03T00:08:45Z
Lists: pgsql-hackers
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