Transaction with in function

[Ravi Katkar <Ravi.Katkar@xxxxxxxxx>]

 

I looking for solution for commit, rollback with in function.

 

Below is Example function

 

 

CREATE OR REPLACE FUNCTION test()

  RETURNS void AS

$BODY$

BEGIN

--- set    of statements

 

Commit;

 

-- set of statement

commit;

 

-- if things goes wrong

rollback

 

   

RETURN;

END; $BODY$

  LANGUAGE 'plpgsql';

 

 

Thanks in advance .

 

Regards

Ravi Katkar