Solution: implicit vs. explicit RETURN when OUT is used

On Fri, 4 Jan 2008 09:38:35 +0100
Ivan Sergio Borgonovo <mail@webthatworks.it> wrote:

> create or replace function testA(out _BasketID1 int, out _BasketID2
> int) as $$
> begin
>     _BasketID1:=1;
>     _BasketID2:=2;
>     return;
> end;
> $$ language plpgsql;
>
> create or replace function testB(out _BasketID1 int, out _BasketID2
> int) as
> $$
> begin
>     select into _BasketID1,_BasketID2  * from testA();
>     return;
> end;
> $$ language plpgsql;
>

> But when I switch to
>
> select into _BasketID1,_BasketID2 _BasketID1,_BasketID2 from
> testA();
>
> nothing get back from testB().

OK switching to:

select _BasketID1,_BasketID2 into _BasketID1,_BasketID2 from testA();
still didn't return anything but
changing the def to

create or replace function testB(out _BasketID1 int, out _BasketID2
int) as
$$
begin
  select a._BasketID1,a._BasketID2 into _BasketID1z,_BasketID2z from
testA() as a;
  return;
end;
$$ language plpgsql;

did work.

here you get the same in a maybe more readable, cut&pastable format:


http://www.webthatworks.it/d1/node/page/returning_composite_type_postgresql_functions_without_declaring_explicitly_composite_type

--
Ivan Sergio Borgonovo
http://www.webthatworks.it