Thread: returning multiple values from a plpgsql function?
Is there any way to return multiple values from a plpgsql function? Ideally I'd like to be able to return two arrays and a scalar value rather than having to pack them into a single longer array. Thanks for your help, Celia McInnis
On Thu, Jun 09, 2005 at 02:42:21PM -0500, Celia McInnis wrote: > > Is there any way to return multiple values from a plpgsql function? Ideally > I'd like to be able to return two arrays and a scalar value rather than > having to pack them into a single longer array. One way is to return a custom type; another way is to return a cursor. See the documentation and the list archives for examples. Here are some links to pages in the 8.0.x documentation that have relevant examples: http://www.postgresql.org/docs/8.0/static/plpgsql-cursors.html#PLPGSQL-CURSOR-USING http://www.postgresql.org/docs/8.0/static/plpgsql-porting.html#PLPGSQL-PORTING-EX3 -- Michael Fuhr http://www.fuhr.org/~mfuhr/