Nigel Horne schrieb:
> 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.
Well, I was sure. And here it is again (from Tom Lane: )
--- cite ---
You've misunderstood this completely. We are not storing anything
essential in the table, we're just using its rowtype to describe the
function's composite-type result.
Personally I would have written the example using a composite type
to make this more clear:
CREATE TYPE test_func_type AS (id int, name text);
CREATE FUNCTION test_func() RETURNS SETOF test_func_type AS $$
SELECT 1, 'me' UNION ALL SELECT 2, 'you'
$$ LANGUAGE sql;
select * from test_func();
id | name
----+------
1 | me
2 | you
(2 rows)
--- cite ---
When this isnt what you want, you are out of options I fear.
Maybe you would write an example of how your hypotetical
function should act?
Regards
Tino
