Обсуждение: 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/