[SQL] commit inside plpgsql function

[Dennis Sacks]

Hi,
I am converting oracle stored procedures to plpgsql. There are several 
of the oracle procedures where a parameter vCommit is passed into the 
procedure and:

if vCommit = 1
   then
       commit;
       do_something_commit(vdate);
   else
       do_something(vdate);
   end if;
does this make sense in plpgsql? Does it make sense to do a commit in 
plpgsql?

Thanks,
Dennis
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match