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

[Hiroki Kataoka]

$BJR2,$G$9!#(B

$B%P!<%8%g%s$H%F!<%V%k9=@.!J%+%i%`$N%G!<%?7?!K$H%U%m%s%H%(%s%I$N%=%U%H%&%'%"$,J,$+$i$J$$$N$G%"%I%P%$%9$G$-$:$K$$$^$7$?$,!"7k2L$r8+$^$9$H!"$*$=$i$/<B?tI=8=$N8m:9$K$h$kLdBj$@$H;W$$$^$9!#(B

$B>u67$+$i$9$k$H(B8.3$B0JA0$r;H$C$F$$$k$N$@$H;W$$$^$9$,!"$@$H$7$?$i(Bcurrent_time$B$N$H$3$m$r(Blocaltime(0)$B$K$9$l$PNI$$$h$&$K;W$($^$9!#@:EY$K(B0$B$r;XDj$9$k$@$1$G!J(Bto_char$B$J$I$NJQ49$r$$$l$:$H$b!K4JC1$K(B1$BICC10L$K4]$a$k$3$H$,$G$-$^$9$N$G!"$3$l$G<B?tI=8=$K$h$k8m:9$O$J$/$J$j$^$9!#(B

8.4$B$G$O(Btime$B7?$K<B?t$r;H$o$J$/$J$j$^$7$?$N$G!"$=$b$=$b$3$NLdBj$O$*$-$J$$$G$9!#(B

$B$A$J$_$K!"(Bwithout time zone$B$J$N$G$9$+$i(Bcurrent_time$B$G$O$J$/$F(Blocaltime$B$NJ}$,E, ＠ Z$@$H;W$$$^$9!#(B

2009/08/25 11:58 $B$K(B $B>.3^!!9d(B<ogasa ＠ oct.email.ne.jp> $B$5$s$O=q$-$^$7$?(B:
>  $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
> cur_time                      time without time zone;
> begin
> cur_time = to_timestamp(to_char(timestamp 'now','HH24:MI:SS'), 'HH24:MI:
> SS');
> INSERT 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
>
>
>



-- 
Hiroki Kataoka