| From: | Nigel Horne <njh(at)bandsman(dot)co(dot)uk> |
|---|---|
| To: | Tino Wildenhain <tino(at)wildenhain(dot)de> |
| Cc: | "A(dot) Kretschmer" <akretschmer(at)despammed(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: |
| Date: | 2005-08-22 13:56:09 |
| Message-ID: | 1124718969.23340.11.camel@laptop1.home-network2.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, 2005-08-22 at 14:49, Tino Wildenhain wrote:
> Nigel Horne schrieb:
> > On Fri, 2005-08-19 at 16:34, A. Kretschmer wrote:
> >
> >>am 19.08.2005, um 15:58:20 +0100 mailte Nigel Horne folgendes:
> >>
> >>>I can't work out from that how to return more than one value.
> >>
> >>17:35 < rtfm_please> For information about srf
> >>17:35 < rtfm_please> see http://techdocs.postgresql.org/guides/SetReturningFunctions
> >>17:35 < rtfm_please> or http://www.postgresql.org/docs/current/static/xfunc-sql.html#AEN28835
> >
> >
> > How does that help with my problem? I seems to discuss returning more
> > than one row of a table which is not the question I asked.
> >
>
> try to tell your questions more precisely :-)
I want to return more than one value from a procedure, e.g. a string and
an integer.
> I think you want to return a record or tabletype.
Not really, since those values could be computed on the fly, they may
not be values in a database.
> IIrc you got the answers to that already :-)
Nope.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-08-22 14:09:42 | Re: http://www.postgresql.org/docs/8.0/static/xfunc-sql.html |
| Previous Message | Tino Wildenhain | 2005-08-22 13:49:15 | Re: |