[pgsql-jp: 39975] FW: ストアドプロシージャのトランザクション?

[小笠 剛]

 $B>.3^$G$9!#(B
$B ＠ hF|$*=u$1%a!<%k$r=P$7$^$7$?0J2<$N7o$K$D$$$F860x$,$o$+$j$^$7$?!#(B

INSERT$B$9$k$H$-$K(Btime (without time zone)$B7?%+%i%`$KD>@\(Bcurrent_time$B4X?t$r;XDj(B
$B$7$FA^F~$7$?$i!"9T$,%m%C%/$5$l$?$^$^$K$J$C$F$7$^$$$^$7$?!#2?$G$J$N$+860x$O$o(B
$B$+$j$^$;$s!#$=$3$G0J2<$N$h$&$K2sHr$$$?$7$^$7$?!#(B

$B!ZNc![(B
INSERT INTO table1 (time) VALUES(current_time);
             $B"-(B

declare
$B!!!!(Bcur_time                      time without time zone;
begin
$B!!!!(Bcur_time = to_timestamp(to_char(timestamp 'now','HH24:MI:SS'), 'HH24:MI:
SS');
$B!!!!(BINSERT INTO table1 (time) VALUES(cur_time);
end;

$B0J>e$G(Btime$B$N%7%j%"%kCM$,:F ＠ _Dj$5$l$FBeF~2DG=$H$J$C$?$h$&$G$9!#9T%m%C%/$5$l$F(B
$B$$$^$;$s!#(B
$B$I$&$b$*A{$,$;$$$?$7$^$7$?!#(B


-----Original Message-----
From: pgsql-jp-bounces ＠ ml.postgresql.jp
[mailto:pgsql-jp-bounces ＠ ml.postgresql.jp] On Behalf Of $B>.3^!!9d(B
Sent: Friday, August 21, 2009 3:29 PM
To: PostgreSQL$B%a!<%j%s%0%j%9%H(B
Subject: [pgsql-jp: 39970]$B%9%H%"%I%W%m%7!<%8%c$N%H%i%s%6%/%7%g%s(B?

$B>.3^$H?=$7$^$9!#(B

$B%9%H%"%I%W%m%7!<%8%c(B(plpgsql)$B$G(BINSERT$B$7$?9T$,(BODBC$B7PM3$G99?7!&:o=|$G$-$J$$$b(B
$B$N$,$"$j$^$9!#(B

$B!Z%9%H%"%I%W%m%7!<%8%c$N35MW![(B

OPEN cur1 FOR SELECT ...........;

loop
    FETCH cur1 INTO rec;

    INSERT INTO table..............;$B!&!&!&-!(B
end loop;

CLOSE cur1;

OPEN cur2 FOR SELECT ...........;

loop
    FETCH cur2 INTO rec;

    INSERT INTO table..............;$B!&!&!&-"(B
end loop;

CLOSE cur2;

$B!Z%9%H%"%I%W%m%7!<%8%c$N35MW(B : $B0J>e![(B

$B>e5-$N%W%m%7!<%8%c$G-!$H-"$OF1$8%F!<%V%k$K9T$rA^F~$7$F$$$^$9!#(B
$B-!$GA^F~$7$?9T$O(BODBC$B7PM3$G99?7!&:o=|$G$-$^$9$,!"-"$GA^F~$7$?9T$O!VB>$N%f!<(B
$B%6!<$,F1;~$K99?7$7$F$$$k!&!&!&!W$H%a%C%;!<%8$,=P$F99?7!&:o=|$G$-$^$;$s!#(B
$B!!$3$N$h$&$J8=>]$K$D$$$F2?$+8+<1$r$*;}$A$NJ}$,$$$i$C$7$c$C$?$i$4;XFn$$$?$@$-(B
$B$?$/$*4j$$?=$7>e$2$^$9!#(B
$B$I$&$>$h$m$7$/$*4j$$$$$?$7$^$9!#(B