PostgreSQL CREATE PROCEDURE

create table akun
(id int generated by default as identity primary key,
name char (100) not null,
balance dec (15,2) not null);

insert into akun (name,balance)
values('Andari', 100000);

select * from akun;

create or replace procedure transfer(int, int, dec)
language plpgsql
as $$
begin

    update akun
    set balance = balance - $3
    where id = $1

    update akun
    set balance = balance + $3
    where id = $2;

commit;
end;
$$