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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings