Hi,
I could only find support for defining functions in pl/pgsql. With a function I can have only one return value. What if I need to have multiple OUT parameters (i.e multiple return values) ? Is there any support for something that is similar to an Oracle stored procedure ?
I understand that I can return a REFCURSOR from a postgres function,
but my question is for a case, say, where I need to return 2 string
variables/values based on some logic in addition to a REFCURSOR. How do I do that in pl/pgsql ?
Example:
create type demotype as ( value1 text, value2 text );
create function returns2strings() returns demotype as ' declare rval demotype; begin rval.value1 := ''some string''; rval.value2 := ''some other string''; return rval; end; ' language 'plpgsql';
-- Bill Moran Potential Technologies http://www.potentialtech.com
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
