Guest User

Untitled

a guest
Jan 10th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION fun1(arg1 numeric, arg2 numeric)
  2. RETURNS numeric
  3. LANGUAGE plpgsql
  4. AS $$
  5. DECLARE
  6. -- <declare variabls>
  7. BEGIN
  8. BEGIN
  9. -- <insert status record>
  10. END;
  11.  
  12. -- <function body>
  13.  
  14. BEGIN
  15. -- <update status record>
  16. END;
  17. END;
  18. $$;
  19.  
  20. Start Function -> insert record to db -> commit -> run function body -> commit -> End function
Add Comment
Please, Sign In to add comment