[SQL] plpgsql out parameter with select into

[Imre Horvath]

Hi!

My question is, how can I get the out parameter from a function with
SELECT INTO by name?
I mean:

create function testfunc1(OUT _status integer) returns integer as
$BODY$
        _status := 0;
$BODY$
language plpgsql;

create function testfunc2() as
declare
        status integer;
$BODY$
        select into status * from testfunc1();
$BODY$
language plpgsql;

create function testfunc3() as
declare
        status integer;
$BODY$
        select into status _status from testfunc1();
$BODY$
language plpgsql;

testfunc2 works, testfunc3 not.

Thanks in advance:
Imre Horvath


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql