| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Celia McInnis <celia(at)drmath(dot)ca> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: returning multiple values from a plpgsql function? |
| Date: | 2005-06-09 21:03:22 |
| Message-ID: | 20050609210322.GA83073@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ennio-Sr | 2005-06-09 21:53:31 | Re: How not to display system tables? |
| Previous Message | Tom Lane | 2005-06-09 20:33:57 | Re: How not to display system tables? |