[pgsql-jp: 40532] ストアドでのOUTパラメーター複数受け渡し

[tadashi tanaka]

$B$O$8$a$^$7$F!#EDCf$H?=$7$^$9!#(B
$B8=:_(BPL/PGSQL$B$K$F3+H/$r9T$C$F$*$j$^$9$,!"(BOUT$B%Q%i%a!<%?!<$N<u$1EO$7J}$,M}2r$G(B
$B$-$:!"<ALd$5$;$FD:$-$^$9!#(B

$B$d$j$?$$;v$O!"%a%$%s4X?t$G;H$C$F$$$k%F!<%V%k7?$NJQ?t$r$=$N$^$^%5%V4X?t$KEO(B
$B$7!"(B
$B%5%V4X?tB&$GI,MW$JCM$rBeF~$5$;$F%a%$%s$KLa$9!"$H$$$&;v$G$9!#(B
$B%F!<%V%k4X?t(B1$B$D$N$_$G<u$1EO$9$HLdBj$J$$$h$&$G$9$,!"F1;~$KB>$NCM$b(BOUT$B%Q%i%a!<(B
$B%?!<$G<u$1EO$=$&$H$9$k$H%(%i!<$H$J$j$^$9!#(B
PostgresSQL$B$N%P!<%8%g%s$O(B8.4.4$B$G$9!#(B

$B0J2<!"%F!<%V%k9=@.$H%a%$%s4X?t!"%5%V4X?t$N%=!<%9$G$9!#(B
CREATE TABLE tab1
(
  col1integer,
  col2 integer
)

$B-!%a%$%s4X?t(B
DECLARE
 hensu1 integer;
 tb tab1%rowtype;
BEGIN
  select * into tb,hensu1 from sub_func(tb);
END;

$B-"%5%V4X?t(B
CREATE OR REPLACE FUNCTION sub_func(INOUT io_tb tab1, OUT o_hensu1 integer)
  RETURNS record AS
BEGIN
  io_tb.col1:=1;
  io_tb.col2:=2;
  o_hensu1:=100;
END;

$B<B9T$9$k$H!"!V7?(Binteger$B$NF~NO9=J8$,L58z$G$9!D!W$N%(%i!<$,H/@8$7$^$9!#(B
$B$I$J$?$+$4;XF36D$2$^$;$s$G$7$g$&$+!#59$7$/$*4j$$CW$7$^$9!#(B