Hello,
how should I retrieve the result from a function with some OUT
paramenters?
(PG is 8.3.7)
here a short example to illustrate my question:
CREATE OR REPLACE FUNCTION test (In a int, OUT b int, OUT c int) AS
$BODY$
BEGIN
b:=a+1;
c:=a+2;
raise notice 'done: %', a;
END
$BODY$
LANGU
Hi,
Marc Mamin schrieb:
how should I retrieve the result from a function with some OUT
paramenters?
(PG is 8.3.7)
here a short example to illustrate my question:
CREATE OR REPLACE FUNCTION test (In a int, OUT b int, OUT c int) AS
$BODY$
BEGIN
b:=a+1;
c:=a+2;
raise notice 'done: %', a;
Hello,
Your proposal unfortunately does not work if you try to query more than one
value and want additional columns in the results,
like in
select column1,test(column1) FROM (values(1),(2)) foo
cheers,
Marc Mamin
>IMO easiest would be to include a RETURNS SETOF record in the
>functio