Tutorial 3 - Banjut

CREATE FUNCTION kaya_mendadak(id varchar, OUT saldo_akhir int) RETURNS int AS $$
DECLARE
        saldo_awal int;
BEGIN
        SELECT saldo INTO saldo_awal FROM nasabah WHERE idnasabah = id;

        IF NOT FOUND THEN
                RAISE EXCEPTION 'nasabah % tak ada', id;
        END IF;

        UPDATE nasabah SET saldo = saldo_awal * 1000 WHERE idnasabah = id;

        SELECT saldo INTO saldo_akhir FROM nasabah WHERE idnasabah = id;
END;
$$ LANGUAGE plpgsql;