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.