plpgsql out parameter with select into
От
Imre Horvath
Тема
plpgsql out parameter with select into
Дата
Msg-id
1282070764.3269.4.camel@cytherian.blemidon.dyndns.org
Список
Дерево обсуждения
plpgsql out parameter with select into Imre Horvath <blemidon@gmail.com>
Re: plpgsql out parameter with select into Pavel Stehule <pavel.stehule@gmail.com>
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
В списке pgsql-sql по дате отправления