[GENERAL] Transaction with in function

[Ravi Katkar]

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